Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
DamienSer
Contributor
Contributor

See null value

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/

Labels (4)
1 Solution

Accepted Solutions
sunny_talwar

How about if you use this expression

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

View solution in original post

4 Replies
vvira1316
Specialist II
Specialist II

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

 

Zero.PNG

 

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

sunny_talwar

How about if you use this expression

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

Hello,

 

Thanks for your quick reply,

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

DamienSer
Contributor
Contributor
Author

Great ! It works !

Many thanks !