topic Re: Trend line chart - null values in App Development

Trend line chart - null values

Wed, 10 May 2017 21:22:39 GMT

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!

Re: Trend line chart - null values

sarahplymale — Thu, 11 May 2017 01:37:15 GMT

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

Re: Trend line chart - null values

Thu, 11 May 2017 15:29:27 GMT

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

Re: Trend line chart - null values

sarahplymale — Thu, 11 May 2017 17:39:26 GMT

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.

Re: Trend line chart - null values

lwestmaas — Fri, 12 May 2017 13:13:49 GMT

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

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