topic Set background color based on value in QlikView

Set background color based on value

Wed, 19 Dec 2012 12:59:01 GMT

Hi all,

I'm trying to set the background color for an expression based on a field value.

For my example table with just one row everything works fine, if there is a second row the background colour isn't set any more.

Ex.:

Fieldvalue T1_RGB: RGB(254,232,200)

Expression for background color: =$(=only(T1_RGB))

Anyone an idea?

Regards

Thomas

Re: Set background color based on value

er_mohit — Wed, 19 Dec 2012 13:04:34 GMT

are you want to change the colour of field value..?if this

then add expresion in text colour.
might be helpful you

Re: Set background color based on value

Wed, 19 Dec 2012 13:15:13 GMT

Hi,

No, i don't want to change the text color, but the color of the background.

But I think the problem is the same also for the text color.

Re: Set background color based on value

Gysbert_Wassenaar — Wed, 19 Dec 2012 13:15:55 GMT

Trying to evaluate field values as expressions like you're trying is a pita. Try adding just the r,g,b values to your table instead of the expression and simply use rgb(r,g,b) as expression for the background color.

[T2_COLOR]:

LOAD * Inline [

T2_RGB,r,g,b

"RGB(254,232,200)",254,232,200

"RGB(253,187,132)",253,187,132

];

Re: Set background color based on value

Wed, 19 Dec 2012 13:23:07 GMT

Separate r,g,b values are working fine. Thanks.

But why isn't it a good idea to put either "RGB(254,232,200)" or "(254,232,200)" as value in a table and use it indirect? Would it be at least possible to evaluate an expressin indirect, or isn't it working at all?

Re: Set background color based on value

Tue, 19 Mar 2013 12:38:05 GMT

Hi,

You can store the information as a color.

You can also use some aggregation functions (when it makes sense).

Please see attached

Hope it helps

Regards