Error on pie chart color

[#1]

Hi,
I have a drill down group which is region and country that region have its own color, i apply this code on background color on expressions

if(GetCurrentField([Region/Country])='Region',RGB(Region_RValue, Region_GValue, Region_BValue))

if i select region, the color work fine for my pie, but when i drill down to country level, the pie turn black color but the legend was show the dafault color. i attach the pic on below.

anyone who has any ideas to solve this error??

[deepakk]

hi,

Select repeat colors from colors tab and check if it solves your problem (Chart Properties) .

[#3]

Hi Deepak,

The repeat last color option doesn't work. Still black. 😕

Attached is the sample QVW...

[kji]

Your color expression is:

=if(GetCurrentField([Region/Country])='Region',RGB(R_Color, G_Color, B_Color))

which means that you will get black whenever your dimensions is not Region (expression evaluates to null).

[#5]

But for some reason, it works for bar chart. It will use the colors that I defined in Color tab if I drill down to Country Level (not Region).

[#6]

but this color expressions look fine for other type of chart except pie and funnel (after select multi-color on color properties) , not sure why the mutli-color option is disable on pie

[johnw]

Looks like a bug to me. The legend shows the right colors, but the chart itself fails to go get the default colors when the expression evaluates to null(). It is at a minimum inconsistent, and I think it's fairly clear that the chart SHOULD have the colors indicated in the legend.

[#8]

Dear Khim,

Kindly share the QV version you using.

There are some bugs in the latest version.

Try creating a sperate application and use the same pie chart.

Do check the expression used.

[#9]

I'm using QV10 SR1

[#10]

QV 10 SR 1 is having some bugs.

I had faced same problem, you try on QV 9.5 it will run perfectly.