Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
HI
In expression tab, click the '+' sign and try like this
=Pick(Match(only(FieldName),'North','Scotland'),blue(),red())
Hope it helps
Under Expressions > Background Color, write your expression.
For example:
If(Region = 'North', RGB(0,0,255),
if(Region = 'Scotland', RGB(255,0,0))
HI
In expression tab, click the '+' sign and try like this
=Pick(Match(only(FieldName),'North','Scotland'),blue(),red())
Hope it helps
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
Thank you all for a prompt response - all sorted now