Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Color entire row red

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!

Dashboard KCE.JPG.jpg

1 Solution

Accepted Solutions
martynlloyd
Partner
Partner

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

Community2.JPG.jpg

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.

View solution in original post

4 Replies
martynlloyd
Partner
Partner

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.

Not applicable
Author

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

martynlloyd
Partner
Partner

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

Community2.JPG.jpg

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.

View solution in original post

Not applicable
Author

Great! Thanks a lot for your help, Martyn!