Qlik Community

Qlik Sense Cloud Discussions

ketanvaria
New Contributor III

Null data showing in Sum Chart

I have a simple line chart that display sum by month. 

 However for December (null field on Data Load table) it display a 0 and the chart look awful. How can I just show the chart non null data only?

6 Replies
Partner
Partner

Re: Null data showing in Sum Chart

let's try to untick "Include zero values" option under Data handling section.
ketanvaria
New Contributor III

Re: Null data showing in Sum Chart

I can't find this! 

Partner
Partner

Re: Null data showing in Sum Chart

Hi Ketanvaria,

To find it, select your chart.

At right > look for the third option "Complements" and untick "Include zero values"

ketanvaria
New Contributor III

Re: Null data showing in Sum Chart

I can't see it - I just can't find the Complements

Highlighted
ketanvaria
New Contributor III

Re: Null data showing in Sum Chart

 

I can't see complements !

 

Partner
Partner

Re: Null data showing in Sum Chart

Look for Data Handling instead of Complements