fix colours

[#1]

Afternoon

I have a number of bar charts which display values for the regions in our company. How do I fix these to be a certain colour

i.e. North = Blue, Scotland = Red etc. I know what the rgb values. I've been trying to put an expression in the colors tab but it doesnt seem to be working

Can someone advise

Thanks

[#2]

Under Expressions > Background Color, write your expression.

[#3]

For example:

If(Region = 'North', RGB(0,0,255),

if(Region = 'Scotland', RGB(255,0,0))

[MayilVahanan · Accepted solution]

HI

In expression tab, click the '+' sign and try like this

=Pick(Match(only(FieldName),'North','Scotland'),blue(),red())

Hope it helps

[swuehl]

Check Henric's recent blog post on how to use consistent colors across multiple charts:

http://community.qlik.com/blogs/qlikviewdesignblog/2012/12/04/colors-in-charts

[#6]

Thank you all for a prompt response - all sorted now