How to Show zero values on Line Chart

[ZoeM]

Hi Community.

I have a weird one where I have a combo line/bar chart and table where in the chart itself I would like to show all months for the respective selection even if the value is zero. Please see chart below:

As you can see in the chart, I am missing February and December because the values are zero. 

In the chart, I have two lines which represent Total (orange) and Filtered result count (green). Though the green line is showing zero for Jan, Mar and Sep values are zero per filtered selection but you can see from the total line that there is associated counts.

Under dimensions, I have unchecked Suppress When Values are Null. When I check Show all Values, it ignores my year filter and I dont want that. 

Under Presentation, I have Unchecked Suppress Zero Values. I also tried to check/uncheck Zero on bars but hat did not change anything.

I only have one dimension which is Year Month. 

Any ideas on how I can get this to work?

Thanks in advance. 

[dplr-rn]

Answered a similar question earlier.

if the data is not present Qlik doesnt show it. instead you will need to add dummy values

check below

https://community.qlik.com/t5/QlikView-App-Development/data-not-present-in-database-but-Qlik-table-s...

[ZoeM]

Thanks for the prompt response Dilipranjith.

So if that is the case, why does zero show in the table but is unable to show in the chart?

Is that visualization limitation?

My data is dynamic due to source, and when filters are changed then values will change. I don't think that solution will be of benefit based on nature of the application. 

Is that the only available work around?

Thanks...

[Brett_Bleess · Accepted solution]

Have a look at the following Design Blog post, it might help, and feel free to backup up to the main Design Blog site and do your own search there as well, lots of things out there that may help on this one...

https://community.qlik.com/t5/Qlik-Design-Blog/NULL-The-Invisible-Nothing/ba-p/1467674

Regards,
Brett

[ZoeM]

Great article. 

Working on how I can present the Nulls in my chart, doe snot get me to the desired result immediately but at least guides me in the right direction.

Thanks for looking into this!