Rank Function?

[qlikuser222]

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

[Frank_Hartmann]

Dimensions:

Name

Category

Expressions:

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

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

[qlikuser222]

thanks for reply,

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

thanks

[NZFei]

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

[Channa]

add one static Column 'Sales'

Just do =Rank(sum(Value))