count if field/column value is null

[dreweezy]

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)

[hopkinsc]

Hi

There isn't much you can do with NULL values,

maybe try

Count(if(isnull(DATE),1,0))

See if that works

[dreweezy]

I was able to use this function and produced the results!

NullCount(['Column_Name'])

[Channa · Accepted solution]

just try isnull(date)

or ismissing(date)

[dreweezy]

This works as well. Thanks Channa!