Conditionally Suppress Zero?

[sarahplymale]

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!

[JonnyPoole · Accepted solution]

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.

[JonnyPoole]

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

[sarahplymale]

Yep, that did it.  Thanks!