Quick Development Tips: Qlikview: Aggregation 2: Dynamic Aggregation in Pivot Table: "vMthLevel = sum(if(aggr(sum(Quantity), Yr,Qtr,Mth,SalesPerson)>2,1,0))
vQtrLevel = sum(if(aggr(sum(Quantity), Yr,Qtr,SalesPerson)>5,1,0))
vYrLevel = sum(if(aggr(sum(Quantity), Yr,SalesPerson)>10,1,0))"
'via Blog this'
No comments:
Post a Comment