topic Re: Background Color from Dimension in QlikView

Background Color from Dimension

robinrouleur — Wed, 02 Dec 2015 06:22:49 GMT

I am trying to set the background color of a chart expression using a dimension containing an RGB(x,y,z) string but it is not working. A screenshot is attached. Can anyone help? Note that the original chart was a bar chart but I'm showing a table chart equivalent to give visibility of the dimension values.

I believe that I am following Henric's instructions in the post below (step 4 in particular) but maybe I'm missing something?

Qlik Design Blog : Colors in charts | Qlik Community

Robin

Re: Background Color from Dimension

rwunderlich — Wed, 02 Dec 2015 07:24:39 GMT

It looks like your SentScalCol field may just be a string "RGB(...)". Did you evaluate the function when you loaded it to create a proper dual color value? If you have your colors stored as string expressions, a simple way to make them proper color duals is to use the evaluate() function at load time.

evaluate(SentScalCol) as SentScalCol

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Background Color from Dimension

Wed, 02 Dec 2015 07:44:03 GMT

How to - Dynamic Look and Feel

it can help You

Re: Background Color from Dimension

tresB — Wed, 02 Dec 2015 07:49:44 GMT

Could you post your sample qvw that demonstrates the issue?

Re: Background Color from Dimension

engishfaque — Wed, 02 Dec 2015 09:13:44 GMT

Dear Robin,

Please try,

=$(SentScaleCol)

Kind regards,

Ishfaque Ahmed

Re: Background Color from Dimension

robinrouleur — Thu, 03 Dec 2015 05:02:20 GMT

Thanks Rob. I thought it was an evaluation issue but couldn't work out how to get it to execute the RGB command string, mainly because I was focussing on doing it at the chart level. Evaluate() during Load did the trick! Here's my Load statement for future reference (the color variables contain RGB() strings:

SentimentScale:

LOAD

PhraseSentiment, PhraseSentiText,

Evaluate(SentScaleCol) AS SentScaleCol

INLINE [

PhraseSentiment,PhraseSentiText,SentScaleCol

2, Very Positive, '$(vDarkGreen)'

1, Positive, '$(vLightGreen)'

0, Neutral, '$(vLightBlue)'

-1, Negative, '$(vOrange)'

-2, Very Negative, '$(vDarkRed)'

];