Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
lailarhc
Creator
Creator

Display values in KPI only if there's a filter selection

Hello.
I have a couple of KPIs and I want them to not show anything unless a particular dimension is selected.

Here's a image of my dashboard:

01_.png

 

I want the KPIs in red to only display values if there's an employee or more selected. How do I do this?
I tried putting GetFieldSelection(Employee) and GetFieldSelection(Employee) = Employee on the Calculation Condition in the Data Handling section, but it doesn't work.

How can I achieve this?
Thank you in advance.

Labels (1)
1 Solution

Accepted Solutions
GaryGiles
Specialist
Specialist

Try using this in the KPI measure expression:

=if(GetFieldSelections([Employee])>0,count(Course),'')

View solution in original post

2 Replies
GaryGiles
Specialist
Specialist

Try using this in the KPI measure expression:

=if(GetFieldSelections([Employee])>0,count(Course),'')

lailarhc
Creator
Creator
Author

It worked. Thank you 🙂