Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Where is "Include Null Values" on Line Chart?

On Qliksense 3.2 Desktop, the documentation for line chart says there is a "Include Null Values" button. However, there is not. This making the scale on my line chart all messed up due to the null values silently forcing the scale up (at least you can find the null bar on the bar chart). I have to convert to Bar Chart, untick the box, then convert to line chart. Is this a bug?

Capture.PNG

3 Replies
devarasu07
Honored Contributor II

Re: Where is "Include Null Values" on Line Chart?

Hi,

I'm using 3.2 SR1 and i can see that check box to include null value option. u can upgrade to below version/

also u have option to exclude dimension and measure null value via set analysis expression

try like 

Sum({$<Client -= {""}>}OrderQty)

also

Untitled.png

Not applicable

Re: Where is "Include Null Values" on Line Chart?

Hey, this doesn't make any difference - that is include zero values, not include null values. e.g. this is my graph with or without the "include null values" button ticked.

include zero values.PNG

This is the chart when converted to a bar chart - you can see the huge null value column on the preview at the bottom which is messing up the scale, far right:

include zero values bar.PNG

This is the bar chart when you untick the "include null value" option which is available under the dimension in the bar chart field, you get this:

exclude null values bar.PNG

Which then you can convert to a line chart. Unticking the "include zero values" box just removes the first two days on this bar chart.

Final line chart:

exclude null values line.PNG

I'm using 3.2 SR4, and the documentation for the line chart says it's supposed to be there under the dimension properties!

https://help.qlik.com/en-US/sense/3.2/Subsystems/Hub/Content/Visualizations/LineChart/line-chart-pro...

I could use a set expression, but in this case I am far more likely to just save it as a master visualisation. However, if this is supposed to be a self-service platform for business users, I really don't expect them to have to go through all these steps or write set expressions - it looks like a bug to me.

Not applicable

Re: Where is "Include Null Values" on Line Chart?

Looks like this is just a Desktop problem - Qliksense Server appears to have the button...!

Community Browser