Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
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

Tags (1)
1 Solution

Accepted Solutions
Partner
Partner

Re: Color entire row red

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.

4 Replies
Highlighted
Partner
Partner

Re: Color entire row red

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

Re: Color entire row red

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

Partner
Partner

Re: Color entire row red

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.

Not applicable

Re: Color entire row red

Great! Thanks a lot for your help, Martyn!