Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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:
Check and uncheck 'suppress null values' doesn't make any sense
In QlikView, I set the background color for the line to transparent (argb(0,0,0,0) if the value is zero