Return Rank against multiple dimension in Qlikview

qlikview
rank

#1

Hi,

In my dashboard, there is four dimensions Country, Region, Category and City. Now I want to return rank for lowest selected dimension against SALES as measure. What do I mean by lowest dimension selected? let’s say:

Scenario -1, Country USA is selected and values of all lower dimensions(in hierarchy) are not selected then lowest selected dimension is Country and rank will represent position among the countries

Scenario -2, Category B is selected and values of dimension City(dimension lower than Category) is not selected then lowest selected dimension is Category and rank will represent among the Categories.

Regards,
Satish


#2

@Satish

This can be done using set analysis and AGGR function. For more detail on it you can refer below link:


Regards,
Sunil