Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Rank(x,1) not working

I'm trying to use rank to display the lowest values, but no matter what I use in the 2nd parameter, the result is the same. I'm using v9 sr3.

3 Replies
Not applicable
Author

Can you give us an example of the 'wrong' results? Steps to repro? your expected result?

We need more detail before we can help.

Not applicable
Author

The wrong result is that Rank(x,1)=1 is the highest value, not the lowest.

I'll upload a QVW to reproduce the error.

Not applicable
Author

In fact, the rank function return a dual format number.

To see the result of changing the 2nd parameter, you need to use =num(rank(var,1)