Bar chart Issue

[vanderson009]

In Qlik Sense i have created bar chart showing Actual Vs Forecast for last 6 months.

My requirement is if any of month has missing actual or forecast then that month should not display on chart.

Thanks,

Villyee

[prajapatiamar38]

Hi Anderson,

You can uncheck "Include Zero Values"  from Add-ons-->Data handling. It will hide the month having no values.

[facettti]

Hi,

Try to put something like this in your bar chart dimension:

=If(Actual>0 and Forecast>0,MonthYear)

[balabhaskarqlik]

May be, Try to Uncheck "Include zero values" option in Add-In.