Conditional formatting based on percentile

[Bdasilva]

Forgive me as I am new to Qlik. I trying to perform conditional formatting on a Qlik pivot table based on percentile for a 3 color gradient. 

How does one write the expression to perform this in Qlik Sense? 

Attached is sample data. 

[KGalloway]

I don't think you can apply a spectrum of color in a pivot table. You can use a nested if statement in the background color to get close to what you want:

The expression I used is if(Sum(value2) > .90, green(), if(Sum(value2) > .70, yellow(), red()))

This is possible in a bar chart (and possible other visualizations). You can color by measure and customize from there: