topic Re: Use colors from variables ? in QlikView

Use colors from variables ?

fredericvillemi — Wed, 08 Jun 2016 12:08:28 GMT

Hello,

I have an Inline data set and I would like it to host a different color for each value.

Load * Inline

[_kpi_curves, _kpi_description, _kpi_color, _kpi_color_value

price, My price, vColPrice, "RGB(180,10,250)"

cost, My cost, vColCost, "RGB(80,10,250)"

mytest, My test, vColTest, "RGB(180,110,250)"

]

What i want to do is a Chart Straight Table with Background Text of each line of the color in kpi_color_value.

I have tried to put _kpi_color_value in the Background Color but it doesn't work.

Second thing I would love to do : instead of using _kpi_color_value, I would prefer using _kpi_color which is the name of the variable containing _kpi_color_value .. How can I use a variable from the name of a variable in such a table ?

Thanks

Re: Use colors from variables ?

vikasmahajan — Wed, 08 Jun 2016 12:15:19 GMT

Refer this .

V/ikas

Re: Use colors from variables ?

Anonymous — Wed, 08 Jun 2016 12:16:25 GMT

Hi Frederic,

Try this:

Load * Inline

[_kpi_curves, _kpi_description, _kpi_color, _kpi_color_value_r, _kpi_color_value_g, _kpi_color_value_b

price, My price, vColPrice, 180, 10, 250

cost, My cost, vColCost, 80, 10, 250

mytest, My test, vColTest, 180, 110, 250

]

Colour function:

RGB(Max({1<_kpi_curves={'price'}>} _kpi_color_value_r),Max({1<_kpi_curves={'price'}>} _kpi_color_value_g),Max({1<_kpi_curves={'price'}>} _kpi_color_value_b))

Kind regards

Re: Use colors from variables ?

fredericvillemi — Wed, 08 Jun 2016 12:45:04 GMT

Hello,

thanks for the example but I don't see the usage of the color in a straight table.

Does it work using only the variable name in Background Color ?

Re: Use colors from variables ?

fredericvillemi — Thu, 09 Jun 2016 07:58:18 GMT

Thanks, that's interesting

Instead of using the RGB function, I will use the 3 colors and keep the RGB function in the background color formula.