Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Channa
Specialist III
Specialist III

DenseRank

I Have two columns

 

Country Sales

 

I need to implement dense rank ..qlik Rank is skipping rank number i want continues ranking

Channa
Labels (1)
3 Replies
Stoyan_Terziev
Partner - Creator III
Partner - Creator III

Hi Channa,

 

Rank function can be substituted by a complex aggr() expression. But before that...

Rank usually works like:

Dimension, Measure, Rank

100, 1

120, 2

120, 2

123,3

126,4

126,4

and etc.

Can you makes sure there are no Null values in your Country dimension?

Here is an example of issue which can mess Rank up:

image.png

Please let me know if that doesn't solve your issue.

 

Kind regards,

S.T.

Channa
Specialist III
Specialist III
Author

Thank you S.T.

 

there are no null values in my country dimension

i need rank on straight table

country, sales,rank

C1,100,1

C2,100,1

C3,99,2

 

qlik rank function is showing 3 for C3 

 

Channa
Dorothy325
Contributor
Contributor


@Channa wrote:

Thank you S.T.

 

there are no null values in my country mykfcexperience dimension

i need rank on straight table

country, sales,rank

C1,100,1

C2,100,1

C3,99,2

 

qlik rank function is showing 3 for C3 

 



Thank you for posting something like this