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

Rank in Reverse Order


Hi all,

I created a Staright table with few dimensions and some expressions including 'Rank()'.

Its working fine .

May I know how can I get Ranking in Reverse order for Descending Sorted Values.

Thanks in advance.

Best Regards,

Susvith

1 Solution

Accepted Solutions
Not applicable
Author

hi

try According to this Attachment.

View solution in original post

11 Replies
Clever_Anjos
Employee
Employee

Rank(-sum(yourvalue))

Clever_Anjos
Employee
Employee

I think that

Rank(TOTAL - if( // the rest of your expression

israrkhan
Specialist II
Specialist II

Hi,

Use a different approach.

like below:

=Rank(- Column(5)),

use your column number, count expressions to count column.

Hope it helps...

Not applicable
Author

try this EX_SHIPPING_SALES_AMOUNT * -1

Not applicable
Author

Thanks for reply ..

But still its not working

Not applicable
Author

Thanks for all your replies...

But nothing is working in my case...

Please let me know if u have any other ideas.

Best Regards,

Susvith

Not applicable
Author

You can attach an app to get right solution

Not applicable
Author

hi

try According to this Attachment.

Not applicable
Author

I cant find any attachment here. Can you please attach the file

THanks