Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
ZoeM
Contributor III

How to Show zero values on Line Chart

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:

Combo Chart.JPG

 

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. 

 

1 Solution

Accepted Solutions
Support
Support

Re: How to Show zero values on Line Chart

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

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
4 Replies
Partner
Partner

Re: How to Show zero values on Line Chart

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

Re: How to Show zero values on Line Chart

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...

Support
Support

Re: How to Show zero values on Line Chart

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

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
ZoeM
Contributor III

Re: How to Show zero values on Line Chart

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!