Pie Chart Calculated Colors

[orital81]

Hi

I have a Pie Chart where I need to define each color by Dimention Value.

I cannot use the default color set since there are cases where I have only

1 Value and then the first color will be taken, this is not an acceptable behaviour.

OTD = 'Y' should have Green Color, OTD = 'N' Should Have Red.

In 2011-Q4 it works good since I have 2 values

But in 2012-Q1 I have 1 value and it's Red, While Should Be Green.

Please advice - How do I set the colors

See attached file for example of my practice on this issue (it didn't quite work).

[lironbaram]

hi

you need to put your colors formula in the expression background color

instead of the colors tab because in the color tab it evaluate the expression out side the chart

i.e. one result to the chart and not one result for every dimension value

[#3 · Accepted solution]

If you check the check box "Persistent Colors" in the colors tab should do the trick for you.

[#4]

If you check the check box "Persistent Colors" in the colors tab should do the trick for you.

[orital81]

Thanks a lot, qlikdisqruser1 had a more simple solution.