Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Ignore 0 value in line chart

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.

1 Solution

Accepted Solutions
simon_hallworth
Contributor II
Contributor II

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.

Show_zero_values.PNG

Simon

View solution in original post

7 Replies
vikasmahajan
Champion
Champion

Select Chart Right Click and Set Min and Max scale

Vikas

Not applicable
Author

actually want to ignore null value instead of treating as 0

Not applicable
Author

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.

tap
Creator
Creator

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

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.

Show_zero_values.PNG

Simon

View solution in original post

petter
MVP
MVP

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

Qlik Sense2.PNG

benwashburne
Partner
Partner

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