Discussion board where members can get started with Qlik Sense.
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:
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].
Am I doing something incorrectly? Or is there a better way to achieve this effect?
Yours sincerely,Casper Westelaken
count( if( IsNull([Ticket.Assignee]),[_Flag_TicketOpen] ) )
View solution in original post
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
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.