topic Re: Suppress Missing not working with color function in QlikView

Suppress Missing not working with color function

Mon, 18 Aug 2014 16:08:15 GMT

Hi all,

I have an application where I use a variable to change which expression will display in a particular chart. I also use a color function to change the color of the bars depending on a goal. Adding this seems to override "suppress missing" under presentation. I can't use suppress zero because for some expressions, zero is a valid result.

I tired using If() instead of sets and that didn't work.

This sheet demonstrates what I mean. The charts are the same except for the color function... the one without the color function works but the one with does not.

Ideas?

Thanks!

Re: Suppress Missing not working with color function

Mon, 18 Aug 2014 16:35:57 GMT

How about using a calculated dimension via the ColorAbove formula to determine if the Org group dimension should be displayed?

Re: Suppress Missing not working with color function

Mon, 18 Aug 2014 16:53:00 GMT

Sounded good, so I tried it. It just replaced the label with "-" ... still showing the missing value. Too bad.