See null value

[DamienSer]

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/

[vvira1316]

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

[sunny_talwar · Accepted solution]

How about if you use this expression

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

[DamienSer]

Hello,

Thanks for your quick reply,

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

[DamienSer]

Great ! It works !

Many thanks !