Dynamic Background Color

[Anonymous]

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

[marcus_sommer · Accepted solution]

Maybe this is helpful for you: Colors in charts.

- Marcus