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.
Can anyone tell me what I'm missing?
Thanks in advance!