Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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

Try this,

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