Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to suppress null values, but still show zero values?

I have a line chart that shows cumulative sums over time, and I want it to chart weeks when the count is zero - but I also want it to suppress weeks where the value is null. The chart's expression is an "if" statement that returns a null() value starting at the day where there's no more data.

The problem is that if I check the "Suppress Zero-Values" box on the chart's Presentation tab, then it suppresses both the weeks where the value is zero and where the value is null, whereas I want it to show the zero weeks but hide the null weeks. Is there a way to do this?

Thanks,

Jeff

2 Replies
Anonymous
Not applicable
Author

what happens when you check "Suppress When Value is Null" in dimensions?

Anonymous
Not applicable
Author

Hi,

Convert all nulls to Zeros in script for that particular field.

Please post sample data,so can help.

Regards

Neetha