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

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
BBB, Sales, 10
BBB, Market, 12
CCC, Sales, 30
CCC, Market, 2


I want create a table in qlik sense showing rank like below when Sales is selected

Name  Category  Value  Rank

AAA             Sales        20       2
BBB                Sales      10      3
CCC                Sales         10   1

 

 

Thanks

Labels (2)
4 Replies
Frank_Hartmann
Master II
Master II

Dimensions:

 

Name

Category

 

Expressions:

 

sum({<Category={'Sales'}>}Value))

aggr(rank(sum({<Category={'Sales'}>}Value)),Name)

 

 

 

 

qlikuser222
Creator
Creator
Author

thanks for reply,

 

we have 20 plus categories, is there any way we can have formula without hardcoding category?

 

thanks

xufei123
Partner
Partner

=only(aggr(rank(total Value),Name))

 

clipboard_image_0.png

Channa
Specialist III
Specialist III

add one static Column 'Sales'

Just do =Rank(sum(Value))

Channa