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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
msapre
Contributor II
Contributor II

How to fix the rank column in table

So I've created a table, where I display the rank of the company (COMPANYNAME) by sum(PARHELD).

In places where the sum(PARHELD) is the exact same, the rank is set as the same for both companies (example below: 16-17 is the rank for 2 different companies).

msapre_0-1747143615324.png

Is there a setting I can change which sets the rank as a unique value? So that one company is rank 16, and the other is rank 17?

Right now the expression for this column is: Rank(Sum(PARHELD)/1000000)

Thanks!

2 Replies
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi there,

Yes, there is. The Rank() function accepts an optional second parameter that defines what to do when the values are exactly the same. The complete list is described in the Help section, however I believe you need to use the number 4 to get a sequence of unique numbers:

Rank(sum(Value), 4)

Cheers,

Oleg Troyansky

Chanty4u
MVP
MVP

Try this 

Rank(Sum(PARHELD)/1000000, 4, 1)

Or 

Rank(Sum(PARHELD)/1000000, 4)