topic Pie Chart Calculated Colors in QlikView

Pie Chart Calculated Colors

orital81 — Wed, 25 Jan 2012 15:08:22 GMT

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 — Wed, 25 Jan 2012 15:13:51 GMT

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

Wed, 25 Jan 2012 15:25:43 GMT

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

Wed, 25 Jan 2012 15:26:22 GMT

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

orital81 — Wed, 25 Jan 2012 15:48:27 GMT

Thanks a lot, qlikdisqruser1 had a more simple solution.