Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Reverse Rank() in Qlikview

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

Tags (1)
1 Solution

Accepted Solutions
Highlighted

Re: Reverse Rank() in Qlikview

Use this:

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

HTH

Best,

Sunny

4 Replies
Highlighted

Re: Reverse Rank() in Qlikview

Use this:

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

HTH

Best,

Sunny

Not applicable

Re: Reverse Rank() in Qlikview

Thanks Sunny

Re: Reverse Rank() in Qlikview

No problem

Glad I was able to help.

Best,

Sunny

prajapatiamar38
Contributor II

Re: Reverse Rank() in Qlikview

Hii

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

This gives the lowest 5 sales based customers.

Hope this helps.

Thanks