How to color a row on condition ?

[suvechha_b]

I want Red color for the row of my Straight Table where Audit Type is Update New .

[suvechha_b]

PFA.

[christophebrault · Accepted solution]

Hi,

you can use this expression as background color (clic on '+' on your dimension/expression) :

=if(audit_type='Update New',rgb(200,0,0))

[its_anandrjs]

In Background option type

if([Audit Type] = 'Update New',Red(),Grey())

Hope this helps

Thanks & Reagrds

[its_anandrjs]

Hi,

Or you can type if([Audit Type] = 'Update New',Red())

check the snap shot

Hope this helps

Thanks & Reagrds

[PrashantSangle]

Hi,

Write this in your dimension tab

go to Property->Dimension->Select Field Name->click on + sign->go to Background Color

write

if([audit type]='Update New',Red())

Write Same expression for all dimension as well as for all Expression ->Background Color

Regards,

[suvechha_b]

Thanks for the answer.

But when I am exporting it to excel . The columns with red color is also becoming black.

Is there any way to export to excel extactly the same as it is showing in qlikview report.