Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

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.

Highlighted
Specialist III
Specialist III

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
Highlighted
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