Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Color in particular column of stright/Pivot Table

Hi Experts,

How to have a color in particular column of a table.

For Ex: If the value of that column is "Yes" then Green color else No Color.

Color.png

1 Solution

Accepted Solutions
bertdijks
Partner - Contributor III
Partner - Contributor III

You can use the background option in the variable, see the next example:

2014-04-14 14_25_24-Edit Expression.pngHi,

Kind Regards,

Bert

View solution in original post

5 Replies
mato32188
Specialist
Specialist

Hi, use Visual Cues in Chart Properties by setting up your value or click on expansion button in Expressions (Chart Properties) and set up Background Color by If statement using the RGB function.

Regards, M

ECG line chart is the most important visualization in your life.
bertdijks
Partner - Contributor III
Partner - Contributor III

You can use the background option in the variable, see the next example:

2014-04-14 14_25_24-Edit Expression.pngHi,

Kind Regards,

Bert

Not applicable
Author

In expression select the background color,then

try the following expr:

=if((your expr)='YES',green())

Not applicable
Author

Thank you Martin

Not applicable
Author

Thank you Bert. It's Working.