Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Rank in reverse order

Hi,

I wanna find the min and max value of a line graph. I have founded a way to do so. But im not able to reverse my rank

If i rank my expression i get the min value as Rank 50 and max Value as Rank 1.

Now i wanna new expression which ranks the other way, so i rank my Min value as 1 or -1 and max value as 50 or -50.

Can anyone help?

Thanks

1 Solution

Accepted Solutions
swuehl
MVP
MVP

If you ranked like

=rank(sum(Value))

then try

=rank(-sum(Value))

so the min of sum(Value) should be ranked 1.

View solution in original post

1 Reply
swuehl
MVP
MVP

If you ranked like

=rank(sum(Value))

then try

=rank(-sum(Value))

so the min of sum(Value) should be ranked 1.