Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
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

1 Solution

Accepted Solutions
sunny_talwar

Use this:

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

HTH

Best,

Sunny

View solution in original post

4 Replies
sunny_talwar

Use this:

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

HTH

Best,

Sunny

View solution in original post

Not applicable
Author

Thanks Sunny

sunny_talwar

No problem

Glad I was able to help.

Best,

Sunny

prajapatiamar38
Creator II
Creator II

Hii

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

This gives the lowest 5 sales based customers.

Hope this helps.

Thanks