topic Re: How to suppress null values, but still show zero values? in QlikView

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

Thu, 11 Dec 2014 20:04:47 GMT

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

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

Anonymous — Thu, 11 Dec 2014 20:07:30 GMT

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

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

Anonymous — Thu, 11 Dec 2014 20:15:21 GMT

Hi,

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

Please post sample data,so can help.

Regards

Neetha