KPI Card to change based on dimension selected

[Serene9595]

Hi All,

I've a Combo chart where there are 2 dimension ReportingQtr and ReportingMth(alternative dimension).

 

I want the KPI card to calculate Month to Month or Quarter to Quarter change based on the dimension selected in the Combo.

Any one can help to advise how I achieve it in QlikSense?

[brunobertels]

hi 

rather than use alternative dimension in your combo chart 

Add a variable button with 2 buttons named month and Quarter set value 1 for month and 2 for Quarter 

create a variable vSwitch = if($(Button) = '1',MonthDim, if($(Button) = '2',QuarterDim)) 

then replace in your combo chart the dimension by vSwith so when you select Month by the button the dimension of the combo chart is set to Month and quarter if you clic the Quarter button. 

For your KPI adapt your mesure that compare month to previous month by replacing the dimension with the variable vSwitch so that, depending of the button you select, the mesure will take the right dimension .

regards