Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
diana_
Contributor II
Contributor II

Include Null values

Hello,

I do choose option 'Include Null Values''. However, months Feb, June where values (formula of difference) are 0s are not appearing in the combo chart. Could you please help? Thanks in advance!!

Best regards,

Diana3..PNG

2 Solutions

Accepted Solutions
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

The values for the month of Feb and Jun is 0 and not null, thus the setting you did wont help.

Do below setting.

Go to properties -> Add Ons -> Data Handling -> Check the option "Include Zero Values"

 

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

Vegar
MVP
MVP

In the chart properties you should check Include zero values: When unselected, measures that have the value ‘0’ are not included in the presentation.

For all properties in the combo chart check out https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/Visualizations/Combo...

View solution in original post

3 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

The values for the month of Feb and Jun is 0 and not null, thus the setting you did wont help.

Do below setting.

Go to properties -> Add Ons -> Data Handling -> Check the option "Include Zero Values"

 

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Vegar
MVP
MVP

In the chart properties you should check Include zero values: When unselected, measures that have the value ‘0’ are not included in the presentation.

For all properties in the combo chart check out https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/Visualizations/Combo...
diana_
Contributor II
Contributor II
Author

Hi,

Thank you very much!

Kind regards,

Diana