1 Reply Latest reply: Aug 29, 2017 7:37 PM by Sunny Talwar RSS

    How can I avoid count a value?

    Andres Garcia

      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,