topic Re: Background colors for expression in QlikView

Background colors for expression

carolin01 — Fri, 14 Mar 2014 10:15:12 GMT

Hello,

I defined the background colors of one of my expressions in my chart as follows:

If([Pareto Class] = 'C', LightRed(), If([Pareto Class] = 'B', LightBlue()))

Now I wonder if I could adjust the color by the following values:

Hue: 140

Sat: 240

Lum: 163

Red: 91

Green: 173

Blue: 255

This would really help me as I´ve a color blind colleague and we agreed on specifc colors that he can see.

Best regards,

Carolin

Re: Background colors for expression

Fri, 14 Mar 2014 10:17:18 GMT

use rgb function:

ex:

If([Pareto Class] = 'C', rgb(91,173,255),red())

Hope this helps

Re: Background colors for expression

its_anandrjs — Fri, 14 Mar 2014 10:25:05 GMT

Hi,

Create a inline table

load * Inline

[

Red,Green,Blue

91,173,255

];

and use this value in RGB( ) function

If([Pareto Class] = 'C',RGB(Red,Green,Blue), red())

You can create a Variables for this also.

Thanks & Regards

Re: Background colors for expression

Fri, 14 Mar 2014 10:33:21 GMT

Hi,

Yes you can convert it using RGB(). Do you want to use the colors you have mentioned instead of LightRed() and LightBlue() respectively then might be something like this would help:

If([Pareto Class] = 'C', RGB(140,240,163), If([Pareto Class] = 'B', RGB(91,173,255)))

Re: Background colors for expression

carolin01 — Fri, 14 Mar 2014 10:39:49 GMT

Thank you, this worked

Re: Background colors for expression

its_anandrjs — Fri, 14 Mar 2014 10:43:36 GMT

Hi,

Other wise write some thing like this

load * Inline

[

Red,Green,Blue,Hue,Sat,Lum

91,173,255,140,240,163

];

and use this value in RGB( ) function

If([Pareto Class] = 'C', RGB(Red,Green,Blue), If([Pareto Class] = 'B', RGB(Hue,Sat,Lum) )

Thanks & Regards