Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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

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