topic Pie Chart Color in QlikView

Pie Chart Color

Tue, 05 Feb 2013 04:14:41 GMT

Hi QlikViewers,

I am faced with a peculiar problem that does not seem solvable our of the box in QlikView.

A piechart has one dimension and one measure. The dimension has say 4 values. Hence there are 4 different color pieces in the pie chart. Say $Sales for North, Souch, East and West regions. I want to color the east region in white(or any other color), and the remaining three pieces in the same color, say Red. Thus the piechart will have only 2 colors at most. Is this doable?

Thanks

Raghu

Re: Pie Chart Color

sreenivas — Tue, 05 Feb 2013 04:59:43 GMT

Goto Expression Tab then select the Expression + symbol in the Bckground colour

Add

If(Dimension='East',RGB(255,255,255),RGB(255,0,0))

Re: Pie Chart Color

Tue, 05 Feb 2013 12:23:44 GMT

Hi Raghuvansh,

You may use the expression :

=if(Region ='east',White(),Red())

in the Chart Properties --> Expressions --> Background Color (Your Expression - sum(sales))

This will solve your problem.

Regards,

Snehal Nabar

Re: Pie Chart Color

Tue, 05 Feb 2013 14:41:53 GMT

Thanks a lot guys.

All of these answers are correct, but I see that I can only mark one answer as correct

Regards

Raghu