Qlik Community

Qlik Sense App Development

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

paulyeo11
Valued Contributor II

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

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

1 Solution

Accepted Solutions
MVP
MVP

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

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

Capture.PNG

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.

3 Replies
MVP
MVP

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

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

Capture.PNG

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.

MVP
MVP

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

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

paulyeo11
Valued Contributor II

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

Hi All

thank you for your help. it work

Paul