Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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 🙂