Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
yvonne-c
Creator
Creator

Include Null values

I have the expression below which is working fine - but I also want to include all IDs where Field "MoveOff" is empty - is there a way to add these into my set analysis?

Count({<Dateon={"<31/10/2018"},MoveOff={">01/10/2018"}ID)


Thanks

Labels (3)
10 Replies
yvonne-c
Creator
Creator
Author

Thanks so much - this one is working!