Pie Chart Color

[#1]

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

[sreenivas · Accepted solution]

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

Add

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

[#3]

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

[#4]

Thanks a lot guys.

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

Regards

Raghu