Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vanderson009
Contributor

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
Contributor II

Re: Bar chart Issue

Hi Anderson,

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

facettti
New Contributor II

Re: Bar chart Issue

Hi,

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

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

balabhaskarqlik
Honored Contributor

Re: Bar chart Issue

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

Community Browser