Dynamic Background Color

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello to all of you,

i have a question. I have a Listbox with KPI Keys. When i select one Key, then i see my Background Color:

When i select another Key, then i also see my Background Color:

But when i deselect the Key, i can't see anything.

I have the following Code for the Background Color:

if(column(1) - column(2) <=minSkala,$(='vF_Wert1_'&concat(Skala,'|')),

if( column(1) - column(2)>=minSkala and column(1) - column(2) <=maxSkala,$(='vF_Wert2_'&concat(Skala,'|')),

if(column(1) - column(2)>=maxSkala, $(='vF_Wert3_'&concat(Skala,'|')))))

I have the following Variables which i want to call for the RGB Code.

So for every %_Key there is a Field "Skala" which contains the number of it.

I want to build dynamically the variablename which contains the RGB Code to prove it again the max and min Skala and then set the color. What i make wrong? I only get it when one is selected. I think the concat function could be the problem?

Thank you for helping me.

Kind Regards

Re: Dynamic Background Color

marcus_sommer — Fri, 15 Jul 2016 14:44:02 GMT

Maybe this is helpful for you: Colors in charts.

- Marcus

topic Dynamic Background Color in QlikView

Dynamic Background Color

Re: Dynamic Background Color