3 Color Gradient in Pivot Table

[chrispatel]

Hello,

I Have made a pivot table that highlights the cells based on the value using the Background color expression. 

ColorMix1( rank(total column(1))/noofrows(TOTAL) , RGB(252,115,98), RGB(77,167,65))

It shows a gradient of green to red, but I would like it to show a gradient of green to yellow to red. I tried a few things but nothing seems to work. 

[MarcoWedel]

did you try with ColorMix2() ?

https://help.qlik.com/en-US/sense/November2022/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/Color...

[chrispatel]

Yes! I was able to solve the issue. Thank you!