Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to colour same cell values in straight table?

Hi,

Would it be possible to colour same cell values.

There is column Status in straight table with values as below

Service

Audit

Development

IT

I need the straight table show complete row values with colour Green wherever the Status value='Service'. in the same way Red when Status='Red'

Please can anyone suggest me

Thanks.

1 Solution

Accepted Solutions
maxgro
MVP
MVP

for all dimensions and expressions

=pick(match(Service, 'Service','Audit','Development', 'IT'), green(), red())

1.png

View solution in original post

4 Replies
Anonymous
Not applicable
Author

goto Expression Status and click on "+"

select textcolor or Background color

and enter

if (Status='Service', red())

or you can define any Color using rgb code instead of red()

  advice: use variable which holds rgb code in that case

maxgro
MVP
MVP

for all dimensions and expressions

=pick(match(Service, 'Service','Audit','Development', 'IT'), green(), red())

1.png

Not applicable
Author

Thanks. Worked.

Not applicable
Author

Thanks.