Discussion board where members can get started with Qlik Sense.
I have a table like below and want to show rank on the table object on Qlik sesne
Name, Category, ValueAAA, Sales, 20AAA, Market, 10BBB, Sales, 10BBB, Market, 12CCC, Sales, 30CCC, 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 2BBB Sales 10 3CCC Sales 10 1
thanks for reply,
we have 20 plus categories, is there any way we can have formula without hardcoding category?
add one static Column 'Sales'
Just do =Rank(sum(Value))