Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Suppress Missing not working with color function

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!

Tags (3)
2 Replies
Not applicable

Re: Suppress Missing not working with color function

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

Not applicable

Re: Suppress Missing not working with color function

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

Community Browser