Reverse Rank() in Qlikview

[#1]

Dear All,

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

Regards,

JKV

[sunny_talwar · Accepted solution]

Use this:

Rank(-Sum(Value)) to get reverse order ranking

HTH

Best,

Sunny

[#3]

Thanks Sunny

[sunny_talwar]

No problem

Glad I was able to help.

Best,

Sunny

[prajapatiamar38]

Hii

Try like this:IF(Aggr(Rank(-SalesValue),Cust_ID)<=5,(SalesValue))

This gives the lowest 5 sales based customers.

Hope this helps.

Thanks