Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
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

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: Rank in reverse order

If you ranked like

=rank(sum(Value))

then try

=rank(-sum(Value))

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

1 Reply
MVP
MVP

Re: Rank in reverse order

If you ranked like

=rank(sum(Value))

then try

=rank(-sum(Value))

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