Filter Controls using IF statements within a kpi

[deerhunter]

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.

[lakshmikandh]

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

[sunny_talwar]

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