topic Re: Filter Controls using IF statements within a kpi in App Development

Filter Controls using IF statements within a kpi

deerhunter — Mon, 15 Aug 2016 23:18:08 GMT

I want to be able to have the default show if nothing is picked to the current year, with the percentage value showing for the Month of December defaulted. (Should show for example = 2015 - $5,000/ 5%)

if the user picks a Quarter and no month, I want the last month of that Quarter used as a default.

(Should show for example = 2015 - $3,800/ 4%)

lastly, the user should only be able to pick a month within the Quarter selected. if possible, only one Quarter/Month at a time.

Re: Filter Controls using IF statements within a kpi

lakshmikandh — Mon, 26 Sep 2016 12:23:51 GMT

Hi,

you can achieve this using Qlik Branchextension,make a drop down combo for selection and default that with desired in the variable.

Thanks,

Lakhsmikandh

Re: Filter Controls using IF statements within a kpi

sunny_talwar — Mon, 26 Sep 2016 13:38:20 GMT

I am unable to get 5000 when I select 2015. Would you be able to suggest if I need to make more than Year selection?

Best,

Sunny