Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikuser222
Creator
Creator

Help with Rank Function

hi All,

I have a table like below and want to show rank on the table object on Qlik sesne
Name, Category, Value
AAA,       Sales,         20
AAA,       Market,     10
AAA,       Revenue,  25
AAA,         Profit,     35
BBB,        Sales,     10
BBB,         Market,  12
BBB,         Revenue,  20
BBB,         Profit,      11
CCC,        Revenue, 35
CCC,           Profit,     50
CCC,          Sales,    30
CCC,         Market,  20

I want create a table in qlik showing rank like below

Name  Category   Value     Rank
AAA       Sales                20        2
AAA         Market            10       3
AAA         Revenue         25       2
AAA            Profit             35       2 
BBB            Sales             10       3
BBB             Market         12        2
BBB            Revenue        20      3
BBB           Profit              11        3
CCC           Sales                30       1
CCC           Market             20        1
CCC           Revenue           38      1
CCC            Profit                50         1

 

 

Thanks

Labels (1)
  • Rank

1 Reply
sunny_talwar

May be this

Aggr(Rank(Value), Category, Name)