topic Re: Conditional color based on a field in QlikView

Conditional color based on a field

Anonymous — Fri, 02 Feb 2018 08:53:16 GMT

Hello,

I'd like to color the backgroud of a cell thank to a value stored in a field

To do it, I made a table with

LOAD * INLINE [

Cod, Desc, BackColor

1, 'First', RGB(255,128,128)

2, 'Second', RGB(255,128,128)

3, 'Third', RGB(255,128,128)

];

I'd like to paint the backgroud of a filed of a pivot table containing the "Cod" field with the color set on the INLINE TABLE; to do it, I set the BackColor fields in the background color of the field I'd like to paint, but it doesn't work 😞

Can anyone help me, pls?

Thanks.

Re: Conditional color based on a field

prma7799 — Fri, 02 Feb 2018 09:10:50 GMT

Try like this...

Re: Conditional color based on a field

Anonymous — Fri, 02 Feb 2018 09:19:04 GMT

Great suggestion!

Thank you so much!

Re: Conditional color based on a field

prma7799 — Fri, 02 Feb 2018 09:30:38 GMT

My Pleasure.....