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

    How can I avoid count a value?

    Andres Garcia




      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?