Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlik gurus, I am stuck on a simple syntax problem.
I imported an excel spreadsheet that has dates in the format - "MM/DD/YYYY"
My field/column is "DATE" which also includes 'N/A' values (as text). It looks like Qlik reads these as a simple null or '-' by doing a simple pivot table I was able to see that.
I want to do a simple count of my DATE column to see how many are null (for a KPI). So I have tried 3 different syntax but no luck.
1. count{<DATE= {'N/A'}>} DATE)
2. count{<DATE= {'-'}>} DATE)
3. count{<DATE= {' '}>} DATE)
Hi
There isn't much you can do with NULL values,
maybe try
Count(if(isnull(DATE),1,0))
See if that works
I was able to use this function and produced the results!
NullCount(['Column_Name'])
just try isnull(date)
or ismissing(date)
This works as well. Thanks Channa!