Discussion board where members can get started with QlikView.
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
Go to Solution.
In expression tab, click the '+' sign and try like this
Hope it helps
Under Expressions > Background Color, write your expression.
If(Region = 'North', RGB(0,0,255),
if(Region = 'Scotland', RGB(255,0,0))
Check Henric's recent blog post on how to use consistent colors across multiple charts:
Thank you all for a prompt response - all sorted now