Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis for Null and Not Null Values

Hi,

I'm trying to create a text object indicating the number of unassigned, open tickets. When I try to use this formula, I think that the $- part of the set analysis is applying to both conditions that I've set, because the number is wildly inaccurate.

=count({$-<actorname={'*'}, Status={'Open'}>} RequestID)

Another way I tried to do this was by subtracting the number of tickets with an open and not null actorname value from the total count of open tickets, but when I validated my data, I found that it wasn't working either. For that, I used this formula:

=count({<Status={'Open'}>} RequestID)-count({<actorname={'*'}, Status={'Open'}>} RequestID)

Is there a way to get the count of tickets with null actorname values which also have a status of 'Open'?

Thanks

14 Replies
sasiparupudi1
Master III
Master III

Count({<actorname-={"''"},Status={'Open'}>} RequestID)

or

Count({<actorname-={"'-'"},Status={'Open'}>} RequestID)

jvitantonio
Luminary Alumni
Luminary Alumni

Hi, you can try using NullAsValue in your script as represented in the attached file.

I hope this helps.

JV !

Not applicable
Author

Thank you!

sasiparupudi1
Master III
Master III

=count({1<actorname={"$(Null())"},Status={'Open'}>} RequestID)

anilmahanty
Contributor III
Contributor III

This is working in QV 12, not in QV 11.