Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
vishus913
Partner - Creator
Partner - Creator

Rank according to two different columns

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?

1 Reply
tresesco
MVP
MVP

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

Capture.JPG