topic Re: Conditionally Suppress Zero? in QlikView

Conditionally Suppress Zero?

sarahplymale — Fri, 29 Aug 2014 19:56:01 GMT

I have a line plot showing case volume for a particular surgical procedure with one line showing this fiscal year and another line showing last fiscal year plotted over the months of the year. I unchecked 'supress zero', because sometimes none of these procedures are done in a given month, so I want to plot to show zero in that case. However, now it is also showing zeros for all the months that are in the future in the current fiscal year. Is there any way to have the plot show zeros when the value is actually zero and not show anything for months that are in the future? (see screenshot attached).

Thanks!

Re: Conditionally Suppress Zero?

JonnyPoole — Fri, 29 Aug 2014 20:14:54 GMT

Qlik will recognize 0's and nulls differently. You can use an if statement to assign either.

Without the QVW i'm not 100% of condition you would write but it could be something like:

if ( Month <= currentmonth , <existingexpression>)

When you don't specifiy an else clause it will compute as a NULL and you can suppress nulls but keep 0's.

share a qvw if it doesn't make sense.

Re: Conditionally Suppress Zero?

JonnyPoole — Fri, 29 Aug 2014 20:38:48 GMT

Just an addon... on the presentation tab , the null suppression is called 'suppress missing'.

Re: Conditionally Suppress Zero?

sarahplymale — Wed, 03 Sep 2014 15:46:03 GMT

Yep, that did it. Thanks!