Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikmark1990
Contributor III
Contributor III

Stop line when no more data is available instead of plotting 0

I have data from 2018 and 2019 to plot in a line graph. The data for 2018 is complete for each week of the year. However 2019 contains the weeks 1 to 5 only in the dataset. Weeks 5 to 52 are plotted as 0 but what I need is that the line of the graph stops at week 4. How can I do this in QLikSense. Plotting the same data in QLikView, the line automatically stops at week 4.

2019-02-13_1452.png

Currently my chart likes like this. I need that the line of 2019 stop at week for instead of plotting the value 0.

My dimensions and measurements are:

2019-02-13_1455.png

Check and uncheck 'suppress null values' doesn't make any sense

2019-02-13_1458.png

Labels (2)
1 Reply
m_woolf
Master II
Master II

In QlikView, I set the background color for the line to transparent (argb(0,0,0,0) if the value is zero