Months with no data are not shown in bar graphs

[QlikSensor]

Hi,

I want to have a bar chart with Month/Year on the x-axis and number of fails in each month. Some months have no fails but qlik sense remove those months with zero values at all. How can I fix that?

[SukumarBera]

Try this.

Chart Property-->Add-ons-->Data handling-->Check "Include Zero Values" option.

Regards,

Sukumar Bera

[JGMDataAnalysis]

Or may be this...

YourMeasure + Sum({1} 0)

If this does not work or what Sakumar proposes, I suggest you review the contents of Generating missing data.pdf

https://community.qlik.com/t5/QlikView-Documents/Generating-Missing-Data-In-QlikView/ta-p/1491394

[QlikSensor]

The tick in the add-on section was already set, but the "Sum({1} 0)" indeed worked. Nevertheless, in some diagrams I have a stacked bar chart. This 2nd dimension is described in the legend as well. As soon as I include the "Sum({1} 0)" all values of this 2nd dimension are shown in the legend (but not only the selected ones). Is there an easy fix or workaround for that?

[JGMDataAnalysis]

I would have to see the measure and dimensions you are using. In the meantime I suggest you review the content of the following link, maybe there you will find the solution...

https://www.naturalsynergies.com/q-tip-20-showing-all-values-in-qlik-sense/

[ioannaiogr]

I'm having the same problem as you @QlikSensor , does anyone know how to restrict to only selected values?