Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jgarciaf106
Creator
Creator

How can I avoid count a value?

Hi,

I wanted to know if in qlik sense its possible to avoid count a value from my data base?

say for example:

This expression helps me to count from HC_Worker_Type all data that is tag as "Employee"

count(total{$<HC_Worker_Type={'Employee'}>} HC_Age_Category)

But aside from I need to count total data that is tag as "Employee" but discard counting based on a second criteria that is tag as Intern

Is that possible?

Thanks,

1 Reply
sunny_talwar

So you want to count those HC_Age_Category where HC_Worker_Type is Employee, but tag is not Intern? Try this

Count(TOTAL {$<HC_Worker_Type={'Employee'}, tag -= {'Intern'}>} HC_Age_Category)