topic Re: QS line chart how to remove null value when most recent period value = 0 in App Development

QS line chart how to remove null value when most recent period value = 0

paulyeo11 — Sun, 06 Mar 2016 16:29:19 GMT

Hi All

i have a line chart to display exp amount by YearQtr.

for 2016 Q4 2016 Q3 2016 Q2 2016 Q1 all are 0 value.

it is possible to remove null value , so that my chart left side will start with Q4 2015 instead of 2016 Q4.

My i know how to set ?

Paul

sunny_talwar — Sun, 06 Mar 2016 16:38:20 GMT

May be by unchecking the 'Show Zero Value' option under Add-ons -> Data Handling

The only issue is that it will hide 0's in any other period also. If that's not what you want, then we will have to explore other options.

swuehl — Sun, 06 Mar 2016 16:38:56 GMT

Go to Chart Properties - Add Ons - Data processing - Disable 'Show Null values'

paulyeo11 — Mon, 07 Mar 2016 00:44:14 GMT

Hi All

thank you for your help. it work

Paul