Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Trend line chart - null values

Hi -

This is my chart. The red and green lines are prior year and budget. I want to show prior year and budget for all 12 months. The blue line represents actuals. I only want the blue line to show through the current month (not display if the value is 0). We are in month 2 of our fiscal year, so it shouldn't show values after month 2, until there are values to show.


Please help! Thank you!

Picture1.png

4 Replies
sarahplymale
Contributor

Re: Trend line chart - null values

Have you tried looking under "Add-ons" --> Data handling --> and un-checking the "Show zero values" box.

2017-05-10_21-35-14.png

Not applicable

Re: Trend line chart - null values

Yes - I tried that, but It doesn't change the trend line. Is there an expression I can use?

Picture2.png

sarahplymale
Contributor

Re: Trend line chart - null values

That calculation condition will just determine if the entire chart should render.  It doesn't apply to individual dimensions or measures.  Are you able to upload the .qvf file?  I'm not sure why the zero or null values are showing.

lwestmaas
New Contributor III

Re: Trend line chart - null values

Hi Lee - I've been able to make this work with something like the following.

if(isnull([expression to graph])=0,[expression to graph])

Community Browser