topic Re: Color entire row red in QlikView

Color entire row red

Tue, 15 Jul 2014 11:41:44 GMT

Hi,

I know how to use visual cues to color the data in one particular cel in my table under certain conditions. Is it also possible to color the entire row of data? So for example, you now see the upperright cel with 307 in it being right, but I also want the related type, origin city, destination city, etc. red.

Thanks!

Re: Color entire row red

martynlloyd — Tue, 15 Jul 2014 11:49:05 GMT

Hi Niek,

Instead of visual clues, expand the expression and select Background Color - you will then be able to define RGB ect, based on values (e.g. nested IF's) for each column.

Also useful if you need more than 3 cues...

regards.

Re: Color entire row red

Tue, 15 Jul 2014 12:06:55 GMT

Hi Martyn,

Thanks, but could you please elaborate on that? How do I expand the expression? (in case it's relevant; I'm using a straight table).

Best regards,

Niek

Re: Color entire row red

martynlloyd — Tue, 15 Jul 2014 13:19:34 GMT

In the expressions tab of the chart, expand the expression by clicking the plus sign to the left of the name

Double click Background Color, and enter your expression

examples:

if(Excel>=20, LightMagenta(), if(Word>=20, Yellow(), ))

=Color(13)

=RGB(192,192,192)

Do the SAME for Dimensions - expand the Dimension and edit the background color.

If you get stuck I'll upload a qvw for you.

ML.

Re: Color entire row red

Wed, 16 Jul 2014 08:31:26 GMT

Great! Thanks a lot for your help, Martyn!