Null values showing when adding text to a pop-up

Dayna — Thu, 17 Sep 2015 13:19:02 GMT

Hello All,

A random issue that I can't believe I haven't hit before now...! I have a bar chart where I'm showing the count of a simple value by a category. On the bar chart, I want to add a value as 'text as pop-up' with the count of how many products. So the calculation at the moment is simply 'count([Complaint Id])'.

To add a bit of detail to this, I want to add some text, so my expression looks like: 'Complaints: '&count([Complaint Id])

However, by adding the text, it's now showing values in the legend for categories that weren't applicable before (no records) - see attached.

Any ideas? Help is always appreciated!!

Kind Regards,

Dayna

Re: Null values showing when adding text to a pop-up

sinanozdemir — Thu, 17 Sep 2015 14:12:41 GMT

Try to suppress null values. If that doesn't work, I usually follow the below:

'Complaints: '&Num((count([Complaint Id]) + 0.001), '0.00') and then suppress zero values.

Hope this helps.

topic Re: Null values showing when adding text to a pop-up in QlikView

Null values showing when adding text to a pop-up

Re: Null values showing when adding text to a pop-up