Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Anderson,
You can uncheck "Include Zero Values" from Add-ons-->Data handling. It will hide the month having no values.
Hi,
Try to put something like this in your bar chart dimension:
=If(Actual>0 and Forecast>0,MonthYear)
May be, Try to Uncheck "Include zero values" option in Add-In.