Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor II

How can I avoid count a value?


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?


1 Reply

Re: How can I avoid count a value?

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)