Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vishuraina
New Contributor II

Calculated Dimension Drop Down Selection

Hi all,

I've made a Calculated Dimension using the below code and the intention is to use this as a drop down filter.

If((Aggr(Rank(Sum(${<YEAR = {$(=Max(YEAR))}>}SALES)),BRAND)) < 6, 'Top 05',

If((Aggr(Rank(Sum({$<YEAR = {$(=Max(YEAR))}>}SALES)),BRAND)) > 6 and (Aggr(Rank(Sum({$<YEAR = {$(=Max(YEAR))}>}SALES)),BRAND)) <= 10, 'Top 05-10',

If((Aggr(Rank(Sum({$<YEAR = {$(=Max(YEAR))}>}SALES)),BRAND)) > 10 and (Aggr(Rank(Sum({$<YEAR = {$(=Max(YEAR))}>}SALES)),BRAND)) <= 15, 'Top 10-15',

If((Aggr(Rank(Sum({$<YEAR = {$(=Max(YEAR))}>}SALES)),BRAND)) > 15 and (Aggr(Rank(Sum({$<YEAR = {$(=Max(YEAR))}>}SALES)),BRAND)) <= 20, 'Top 15-20',

If((Aggr(Rank(Sum({$<YEAR = {$(=Max(YEAR))}>}SALES)),BRAND)) > 20 and (Aggr(Rank(Sum({$<YEAR = {$(=Max(YEAR))}>}SALES)),BRAND)) <= 25, 'Top 20-25',

If((Aggr(Rank(Sum({$<YEAR = {$(=Max(YEAR))}>}SALES)),BRAND)) > 25 and (Aggr(Rank(Sum({$<YEAR = {$(=Max(YEAR))}>}SALES)),BRAND)) <= 30, 'Top 25-30'))))))

While the logic works fine and i'm able to use this as a filter, the problem is every time is select any drop down option apart form 'Top 05', the selections are done correctly, however it shows 'Top 05' in the filter options.

Ex :  If i select 'Top 10-15' the selections made are correct & logical, but the drop down shows the selected field as 'Top 05'.