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
Big Bet Webinar, March 10th: Learn 7 ways to accelerate business insights REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vanderson009
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
prajapatiamar38
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.

facettti
Partner
Partner

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.