Rank according to two different columns

[vishus913]

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?

[tresesco]

I have done in qlikview, and the same expression should work in qlik sense as well.