Skip to main content
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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?

1 Reply
Specialist II
Specialist II

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.