Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor

Expression if nothing is selected

Hello, I am using expression to define value of plan in KPI object. I am using IF statement: =max(if ([AREA]='name', Value, if([AREA]='name 2', '30'))). 30 I would like to display if nothing is selected (no area is selected) however cannot make it working. Can anyone help with this issue?

Tags (2)
1 Reply
Valued Contributor II

Re: Expression if nothing is selected

Hi Anastasiia,

I don't understand truly, but I think the getselectedcount function can help you

=if(getselectedcount(AREA)=0,'What you want to show when nothing is selected',max(if ([AREA]='name', Value, if([AREA]='name 2', '30'))))

or similar logic.