Discussion board where members can get started with Qlik Sense.
I Have two columns
I need to implement dense rank ..qlik Rank is skipping rank number i want continues ranking
Rank function can be substituted by a complex aggr() expression. But before that...
Rank usually works like:
Dimension, Measure, Rank
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.
Thank you S.T.
there are no null values in my country dimension
i need rank on straight table
qlik rank function is showing 3 for C3
@Channa wrote:Thank you S.T. there are no null values in my country mykfcexperience dimensioni need rank on straight tablecountry, sales,rankC1,100,1C2,100,1C3,99,2 qlik rank function is showing 3 for C3
there are no null values in my country mykfcexperience dimension
Thank you for posting something like this