Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
deerhunter
Contributor

Filter Controls using IF statements within a kpi

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.

2 Replies
lakshmikandh
Valued Contributor II

Re: Filter Controls using IF statements within a kpi

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

MVP
MVP

Re: Filter Controls using IF statements within a kpi

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

Capture.PNG

Community Browser