Discussion Board for collaboration related to QlikView App Development.
As you know the RANK() function return the RANK in largest value bases. how can i get rank() on lowest base.
ex lowtest get rank 1 and so on
Go to Solution.
Rank(-Sum(Value)) to get reverse order ranking
Glad I was able to help.
Try like this:IF(Aggr(Rank(-SalesValue),Cust_ID)<=5,(SalesValue))
This gives the lowest 5 sales based customers.
Hope this helps.