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