Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

nsm1234567
Contributor

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

Re: Qliksense Line Charts showing zero values

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
Contributor

Re: Qliksense Line Charts showing zero values

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.