If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have one table:
TaskName, UserID, UserEnabled
I need to count Distinct TaskNames for only the tasks having UserEnabled as 'F' or NULL only.
So the output should be:
Distinct count should be 2.
One question, Is the 'NULL' in the code above being read as a text value or as NULL value which is usually shown as - in table.
Also I am trying in on my KPI in front end.
Yes please, I want to use actual NULL.
To explain the requirement again. I need to find the distinct count of TaskName which have their entire UserEnabled as the following combinations:
TaskName, User, UserEnabled
A, 1, False
A, 2, False
B, 3, False
B, 4, Null (Not text value. This is actual NULL)
C, 5, Null
So the distinct count of the TaskName will be 2 (TaskName: A,B,C will be counted).
So I want TaskNames which have all their users as False or NULL(Not text value but actual NULL).