Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
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)