topic Error on pie chart color in QlikView

Error on pie chart color

Fri, 11 Feb 2011 09:10:40 GMT

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??

Error on pie chart color

deepakk — Fri, 11 Feb 2011 09:24:49 GMT

hi,

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

Error on pie chart color

Fri, 11 Feb 2011 09:52:05 GMT

Hi Deepak,

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

Attached is the sample QVW...

Error on pie chart color

kji — Fri, 11 Feb 2011 10:01:06 GMT

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).

Error on pie chart color

Fri, 11 Feb 2011 10:04:16 GMT

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).

Error on pie chart color

Fri, 11 Feb 2011 10:07:52 GMT

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

Error on pie chart color

johnw — Sat, 12 Feb 2011 02:18:23 GMT

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.

Error on pie chart color

Sat, 12 Feb 2011 05:58:22 GMT

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.

Error on pie chart color

Sun, 13 Feb 2011 03:27:01 GMT

I'm using QV10 SR1

Error on pie chart color

Sun, 13 Feb 2011 04:25:22 GMT

QV 10 SR 1 is having some bugs.

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