1 Reply Latest reply: Dec 22, 2015 7:10 PM by Stefan Wühl RSS

    distinct count that keeps all selections besides the WHERE condition

      Hi Experts,

       

      I'm new to Qlik but familiar with SQL so please forgive any incorrect terms.

       

      I'm trying to write an expression return the distinct count of the values in [Visit.Event.ID] where the field [Department] = ''Repair' and every other user selection applies also.  (i.e. Dealership, Grade, etc)

       

      This seems to be close, but not quite. 

       

      Count({$<Department={'Repair'}>}Visit.Event.ID)

       

      Can anyone tell me what I'm missing?

       

      Thanks in advance!