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: 
jbchurchill
Creator
Creator

Access to Blank Records in a Set Expression

I have this working (in a KPI) in a Qlik Sense App.

=Count({<[close_date]={"<>=$('')"}>}[service_id])

It shows a count of all non-blank records. I'm ultimately trying to do more with it but first I want to get the reverse of this (I need to access all the "blank records". How would I reverse this to get the count of the rest of the records?

Labels (1)
2 Replies
jbchurchill
Creator
Creator
Author

Never mind - I figured this part out. I just did this ...

=Count({1-<[close_date]={"<>=$('')"}>}[service_id])

Saravanan_Desingh
MVP
MVP

Try this,

=Count({<[close_date]={"*"}>}[service_id])