Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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/
How about if you use this expression
=Count({<Field_of_Incidents={'1 - Critical'}>}Field_of_Incidents) + Sum({1} 0)
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
How about if you use this expression
=Count({<Field_of_Incidents={'1 - Critical'}>}Field_of_Incidents) + Sum({1} 0)
Hello,
Thanks for your quick reply,
Yes I've already do that, and If I select or unselect I've the same thing.