Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Zeros and Null Values in Chart

Hi

I have a chart which has both Zero and Null Values.

The Null values mean there is no data to report, but the Zero Values need to be recorded.

Is there any way to display just the data recorded, and to ignore the Null values.  I still need to report Zero values.

Thanks

3 Replies
rupamjyotidas
Specialist
Specialist

Try removing 'Suppress Zero-Values' Tick in Presentation Setting of the chart.

Not applicable
Author

What does supress nulls actually mean?

If this is selected, will it ignore Zero values too?

rupamjyotidas
Specialist
Specialist

'Suppress Zero-Values' will suppress the Zero Values if any

'Suppress Null/Missing' will suppress if values are not present.