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

Announcements
Join us at Qlik Connect 2026 in Orlando, April 13–15: Register Here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Zazy
Contributor
Contributor

Set Analysis to show number of Embloyees

Hello everyone

Im new in qliksense  

I need help with this question 

I want to show in KPI 

First Number of Employees in Sales without the President (Set Analysis).

Second: Number of Administration Employees (Set Analysis).

 

Thank in advance 

 

Labels (1)
2 Replies
MayilVahanan

Hi

I think, role is Administration , President, etc.. if the case, Try like below

1. Count({<Role -={'President'}>}Distinct Employees)

2. Count({<Role ={'Administration '}>}Distinct Employees)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Zazy
Contributor
Contributor
Author

thank you Mayil Vahanan  for your respond,

but i have problem now, it shows me the total number of employees 

1.png