How to conditionally format the total row in a table?

[aamer007]

Hi Community,

I am trying to conditionally format the total row in my table.

I have a table in QLIK SENSE, and I want to color the TOTAL row in it. I have tried with function.
Isnull(row()) and dimensionality().
and also use other expression for achieving Total color.
my expression
= If(Even(RowNo(TOTAL)) , RGB(203, 209, 225), RGB(231,234,241))

but none of these seems to work.
my requirement is that total should be in red when values are in -ve and should be in green when values are in +ve.
For e.g The value of Total or -90.4% should be in Red.

Pls find attached snapshot for your reference.

Can someone help me in this?

[Kushal_Chawda]

@aamer007  how many dimensions are there in your pivot table?

[aamer007]

@Kushal_Chawda I m using table chart only with one dimension and five measures.

[ramchalla]

@aamer007 Please use the below expression in Text Color Expression in Bud Var% measure.

if(Dimensionality()=0, if( (entire formual for Bud Var%) >0, Green(), Red()))

[aamer007]

Hi @ramchalla ,

This also not working.

[ramchalla]

@aamer007 if possible, can you please provide some sample data.

[aamer007]

@ramchalla  Yes , I have attached a sample Data sheet.

[Anil_Babu_Samineni]

Color expression should understand measure expressions. So try to attach QVW or QVF? Otherwise, Again need to work, If our guess not correct.

[Kushal_Chawda]

@aamer007  you can try below expression in background color or text color  of Measure BUD Var%

=if(Dimensionality()=0, if( (Your BUD Var% Expression) <0, red(),green()))

[aamer007]

hi @Kushal_Chawda ,

Its not working ,