Discussion Board for collaboration related to Creating Analytics for QlikView.
I'm making pivot table with dimesions and expressions described on the picture.
How can i use rank function in calculated dimension to select best 5 points of sales?
Many thanks for help!
Go to Solution.
Something like this: =aggr(if(rank(sum(Sales))<=5,[Sales Point]),[Sales Point])
Change Sales and Sales Point to reflect your real dimension names.
But try to use Dimension Limits instead. Those are less costly than calculated dimensions.
IF(Aggr(Rank(SUM([Qty of Sales]),4),[Sales Point]<=5,[Sales Point])
Tick Suppress When Value is Null
SUM([Qty of Sales])
Dear, thank you.