topic Re: Conditional expressions mess up Chart Colors in QlikView

Conditional expressions mess up Chart Colors

pennetzdorfer — Thu, 30 Aug 2012 10:57:58 GMT

Hey,

I've a simple bar chart containing 3 expressions. For each of them I need a specific color, which I've defined in the "Colors" tab.

Expression 1 - green

Expression 2 - yellow

Expression 3 - red

Now I set a conditional show statement for expression 1. In case the condition doesn't apply, expression 1 disappears ... so far so good.

But unfortunately the colors for the other expressions change (expression 2 - green, expression 3 - yellow) ...

Do you have any idea how to keep the predefined colors for each expression?

(I've already checked/unchecked "Persistent Colors" - but it doesn't work in this case)

Thx!

whiteline — Thu, 30 Aug 2012 11:11:10 GMT

You can assign colors manualy.

Expand each expression and for Background Color Type:

=color(N)

where N is the number of expression (it's also the number in the color table).

pennetzdorfer — Thu, 30 Aug 2012 11:16:24 GMT

Great, thanks a lot! I didn't know that function