Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Never mind - I figured this part out. I just did this ...
=Count({1-<[close_date]={"<>=$('')"}>}[service_id])
Try this,
=Count({<[close_date]={"*"}>}[service_id])