Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Master II
Master II

Dimensions:

 

Name

Category

 

Expressions:

 

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

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

 

 

 

 

Highlighted
Creator
Creator

thanks for reply,

 

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

 

thanks

Highlighted
Partner
Partner

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

 

clipboard_image_0.png

Highlighted
Specialist III
Specialist III

add one static Column 'Sales'

Just do =Rank(sum(Value))

Channa