Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Count Column A if Column B has no date

Please advise, Trying to count A where B date fields are blank. Cannot do a replace Null  with 'No Date' in the data table as this is not available in date formats.

Count({<[Open/Closed/Void]={'Open','Eff-Check'}>}[Open/Closed/Void] and [Planned Closure Date]-='*')

4 Replies
Highlighted
Master III
Master III

Re: Count Column A if Column B has no date

Maybe like this

 

Count({<[Open/Closed/Void]={'Open','Eff-Check'},[Planned Closure Date]-={' '}>}[Open/Closed/Void])

Highlighted
Contributor III
Contributor III

Re: Count Column A if Column B has no date

Unfortunately this solution is not working for me.

Highlighted
Master III
Master III

Re: Count Column A if Column B has no date

Do you have the null values in [Planned Closure Date]?

 

Can you share the sample app with expected output

Highlighted
Contributor III
Contributor III

Re: Count Column A if Column B has no date

Cheers, Yes I have null values in the date column (that is the real problem)

I will try to put a small app together and forward.

Kind Regards

Patman