Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I Have two columns
Country Sales
I need to implement dense rank ..qlik Rank is skipping rank number i want continues ranking
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:
Please let me know if that doesn't solve your issue.
Kind regards,
S.T.
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 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