topic How to colour same cell values in straight table? in QlikView

How to colour same cell values in straight table?

Fri, 18 Sep 2015 11:04:53 GMT

Hi,

Would it be possible to colour same cell values.

There is column Status in straight table with values as below

Service

Audit

Development

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.

Anonymous — Fri, 18 Sep 2015 11:15:45 GMT

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 — Fri, 18 Sep 2015 11:24:55 GMT

for all dimensions and expressions

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

Fri, 18 Sep 2015 12:00:05 GMT

Thanks. Worked.

Fri, 18 Sep 2015 12:04:10 GMT

Thanks.