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: 
nsm1234567
Creator II
Creator II

Qliksense Line Charts showing zero values

Hi There,

I'm trying to find a way to deal with the way Qlik Sense seems to handle zero values in a line chart.  in the below chart,Sense seems to plot the zero values in the chart.  This leads to a strange looking chart like the one below with the overlapping line.  Is there something I can set on the chart to avoid this without changing the expression?  I've attached the QVF for the below image.

chart1234.png

2 Replies
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi Nathan,

I don't think there is anything "out of the box" that could eliminate zeros from being plotted. The work-around that I'd use is to replace zeros with nulls, using a simple IF condition. See attached

Cheers,

Oleg Troyansky

Upgrade your Qlik skills at the Masters Summit for Qlik - coming to Boston, MA this October!

nsm1234567
Creator II
Creator II
Author

Thanks Oleg.  I had been hoping to avoid nulling the else conditions as I didn't want to add additional complexity to the expressions (in the app we're porting to Sense the underlying expression is already quite complex), but I think we may end up just nulling these or switching to a bar chart.