Color gradient in pivot

[Qliksense_77]

Hi

I need to background color a pivot table with green if the measure is between 0.8 to 0.9. 

If the measure is not between 0.8 to 0.9 the backgrpund color should be red. 

And the tricky part is that the red color has to be gradient. The further the measure is from 0.8 to 0.9 the more dark red the background color has to be.

Anybody that can help ?

[VBD · Accepted solution]

Hello, you can try something like that

IF(
Measure1 >= 0.8 AND Measure1 <= 0.9,
rgb(0, 255, 0), 
rgb(255, (1 - fabs(Measure1 - 0.85) * 10) * 255, (1 - fabs(Measure1 - 0.85) * 10) * 255) 
)

Regards,

[Qliksense_77]

@VBD , thanks:)