Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Creator III
Creator III

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

Add

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

View solution in original post

3 Replies
sreenivas
Creator III
Creator III

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
Author

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
Author

Thanks a lot guys.

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

Regards

Raghu