Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ag732312
New Contributor II

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
MVP
MVP

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)