QlikSense Condition row colour deplay for value > 5

[nidhi23dec]

HI, I am using Qliksense and I want to change row color red when a field called variance is > 5%. in pivot table.

my pivot table has 4 dimension and 4 measure  and last measure is variance which will decide the color of row.

please help, i could find better option to change it..

[Dalton_Ruer]

You will need to use a color expression for each of the columns that sets either the background or the text color as you desire. Something like:

If(MyExpression > .05, Red(), White())

I don't think you will like the out of the box red value. You can also use the RGB function instead to create the perfect Red for your needs:

If(MyExpression > .05, RGB(39,130,39), White())

Or you can use the HEX expression 

If(MyExpression > .05, '#ac4d58', White())