Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Pie Chart Color

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

1 Solution

Accepted Solutions
sreenivas
Contributor III

Re: Pie Chart Color

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 Replies
sreenivas
Contributor III

Re: Pie Chart Color

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

Add

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

Not applicable

Re: Pie Chart Color

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

Not applicable

Re: Pie Chart Color

Thanks a lot guys.

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

Regards

Raghu

Community Browser