Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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)