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: 
cawestelaken
Contributor II
Contributor II

Count if equals null()

Hello,

I'd like to show the amount of open tickets which do not have an assignee (look at situation below)

To do this I've used the following measure:

count(if([Ticket.Assignee]=null(),[_Flag_TicketOpen]))

But for some reason it does not give the results expected.

In the picture below, in the left table you can see all open tickets. In the right table you can see all unassigned open tickets, in this table the above measure is included.

In the table underneath you can see that these selected tickets most definitely have a null value as [Ticket.Assignee].

Capture3.PNG

Am I doing something incorrectly? Or is there a better way to achieve this effect?

Yours sincerely,
Casper Westelaken

1 Solution

Accepted Solutions
agigliotti
Partner - Champion
Partner - Champion

maybe this:

count( if( IsNull([Ticket.Assignee]),[_Flag_TicketOpen] ) )

View solution in original post

3 Replies
agigliotti
Partner - Champion
Partner - Champion

maybe this:

count( if( IsNull([Ticket.Assignee]),[_Flag_TicketOpen] ) )

juraj_misina
Luminary Alumni
Luminary Alumni

Maybe try

count(if(IsNull([Ticket.Assignee]),[_Flag_TicketOpen]))

But the best approach would be to replace null with some value (e.g. "unassigned" or something) during data load, then you could easily filter on that value.

Hope this helps

Juraj

cawestelaken
Contributor II
Contributor II
Author

As stated in the correct answer, that indeed works... Sadly with the loading, I do not control this myself, so I'd have to try to fix that higher up.