Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

Bar chart Issue

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

3 Replies
Creator II
Creator II

Hi Anderson,

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

Partner
Partner

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.