Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

fix colours

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

1 Solution

Accepted Solutions

Re: fix colours

HI

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

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

Hope it helps

5 Replies
Not applicable

Re: fix colours

Under Expressions > Background Color, write your expression.

Capture.JPG

Not applicable

Re: fix colours

For example:

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

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

Re: fix colours

HI

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

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

Hope it helps

MVP
MVP

Re: fix colours

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

Not applicable

Re: fix colours

Thank you all for a prompt response - all sorted now

Community Browser