Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Maybe just a DISTINCT qualifier?
Count({$<Department={'Repair'}>} DISTINCT [Visit.Event.ID] )
Maybe just a DISTINCT qualifier?
Count({$<Department={'Repair'}>} DISTINCT [Visit.Event.ID] )