Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
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

Tags (3)
1 Solution

Accepted Solutions
Not applicable

Re: Rank in Reverse Order

hi

try According to this Attachment.

11 Replies
Employee
Employee

Re: Rank in Reverse Order

Rank(-sum(yourvalue))

Employee
Employee

Re: Rank in Reverse Order

I think that

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

israrkhan
Valued Contributor II

Re: Rank in Reverse Order

Hi,

Use a different approach.

like below:

=Rank(- Column(5)),

use your column number, count expressions to count column.

Hope it helps...

Not applicable

Re: Rank in Reverse Order

try this EX_SHIPPING_SALES_AMOUNT * -1

Not applicable

Re: Rank in Reverse Order

Thanks for reply ..

But still its not working

Not applicable

Re: Rank in Reverse Order

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

Re: Rank in Reverse Order

You can attach an app to get right solution

Not applicable

Re: Rank in Reverse Order

hi

try According to this Attachment.

Not applicable

Re: Rank in Reverse Order

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

THanks