topic Re: fix colours in QlikView

fix colours

Fri, 07 Dec 2012 14:36:03 GMT

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

Re: fix colours

Fri, 07 Dec 2012 14:38:17 GMT

Under Expressions > Background Color, write your expression.

Re: fix colours

Fri, 07 Dec 2012 14:39:40 GMT

For example:

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

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

Re: fix colours

MayilVahanan — Fri, 07 Dec 2012 14:43:41 GMT

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

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

Hope it helps

Re: fix colours

swuehl — Fri, 07 Dec 2012 14:51:01 GMT

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

Re: fix colours

Fri, 07 Dec 2012 15:10:01 GMT

Thank you all for a prompt response - all sorted now