Discussion Board for collaboration on QlikView Layout & Visualizations.
I have file with such columns: MetricID, MetricValue, MetricColor
Metric color has format 'RGB(X,Y,Z)'
On a chart I want to represent each metric with color from MetricColor column. How can I do it?
Go to Solution.
In your script load statement, use the evaluate function to convert your rgb() syntax to proper color numbers:
evaluate(MetricColor) as MetricColor
Click the + next to your expression. For the Background Color attribute enter:
In my experience you have to assign a separate field to each color components (Red, Green, Blue) then assign the background color to each expression using the RGB function:
=RGB(RedFieldName, GreenFieldName, BlueFieldName)
My suggestion which works well for me is to load the RGB value for each RGB along with the value see below and then click the plus sign for background in Expression Tab as