Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save $300 - Register for QlikWorld (formerly Qonnections) by January 31st: Learn More
cawestelaken
New 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
Partner
Partner

Re: Count if equals null()

maybe this:

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

View solution in original post

3 Replies
Partner
Partner

Re: Count if equals null()

maybe this:

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

View solution in original post

Luminary
Luminary

Re: Count if equals null()

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
New Contributor II

Re: Count if equals null()

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.