topic See null value in QlikView

See null value

DamienSer — Sat, 16 Nov 2024 04:43:49 GMT

Hello all,

I've a quick problem with a chart in QlikSense.

I would like to display value month by mont. But sometimes the month on my chart not appears because value is null.
I've custom on my measure this formula :

=Count({<Field_of_Incidents={'1 - Critical'}>}Field_of_Incidents)

You can see taht I filter by priority and I would like to have only critical Priority( 1 - Critical)
If I do that, it works but if on month decembre, for example, there is no value, I can't see this month on my chart.

The goal is to have each month eveni if the count is 0 for this priority.

Have you an idea ?

Many thanks for your help,

Damien/

Re: See null value

vvira1316 — Thu, 17 Jan 2019 14:36:45 GMT

Have tried checking Include Zero Values on your chart. It is usually found on right hand side under Add-ons > Data handling

Also you may try checking Include null values for your month dimension

Re: See null value

sunny_talwar — Thu, 17 Jan 2019 14:39:41 GMT

How about if you use this expression

=Count({<Field_of_Incidents={'1 - Critical'}>}Field_of_Incidents) + Sum({1} 0)

Re: See null value

DamienSer — Thu, 17 Jan 2019 14:41:03 GMT

Hello,

Thanks for your quick reply,

Yes I've already do that, and If I select or unselect I've the same thing.

Re: See null value

DamienSer — Thu, 17 Jan 2019 14:47:38 GMT

Great ! It works !

Many thanks !