Ignore 0 value in line chart

[#1]

Sorry if this is a dumb question.  I am new to Qlik Sense and struggling a bit to solve what i expect is a simple problem.  i have a line chart with several measures.  the chart should show data points over time.  some weeks will not have data yet.  i want the line to stop.  instead, the application plots the data as 0.  see below:

the highest line goes from 30 in -w8 to 0 in -w7.  I would like the line to just stop at 30.

thanks.

[vikasmahajan]

Select Chart Right Click and Set Min and Max scale

Vikas

[#3]

actually want to ignore null value instead of treating as 0

[#4]

hey vikas-

thanks for the response.  your example looks like qlikview.  but i did try to change the min/max in qlik sense and it didnt impact the chart. 

thx though.

[Anonymous]

If you go to the "Dimension" property on the right, and look at the "Limitation" drop down.

Select "Exact Value"

Then ">"

and 0.

Untick "Show others" and it will then only display values > 0.

[simon_hallworth · Accepted solution]

Hi Greg,

In the properties panel click the Add-ons section and then click Data handling to see the options - at the moment there is just one option labelled Show zero values which you need to un-tick.

Simon

[petter]

Yes there is at least a couple of ways of achieving this - I have attached a Qlik Sense app that illustrates the two approaches. Which one you use depends on how you do your dimension and measure choices...

[benwashburne]

@petter  Thank you for the very simple solution. The if(sum...null()) works very well.