Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a table like below
Category SubCategory
A a
A b
A c
B x
C a
C d
Now I want a output like below:
Category SubCategory SubRank Rank
A a 1 1
A b 2 1
A c 3 1
B x 1 2
C a 1 3
C d 2 3
Is there a way I can achieve the same in qlik Sense?
I have done in qlikview, and the same expression should work in qlik sense as well.