Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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