I have table like this
I want a measure to Count UserId whose date is not null
I found lots of options but none of them is working.
How are ur Null values defined? as a strgin 'Null' ?
If so: try:
(depends on how ur null values are defined)
ps: Qlik does not count Null values that appear as '-' in grey
Thanks for your answer
Out of 4 answers , 3 are working for me.
I don't know how my null values are defined but it appears as '-' in grey.
I am not sure what the problem is here - Count() only counts non-nulls by default.
Perhaps if you provided slightly more information, the problem would be clearer.
I think his Null values are defined as Strings.. not really Null values.. but maybe spaces.. don't know
Retrieving data ...