Gradient color using pivot table

[JRamos]

Hi all, 

I'm trying to modify the text color with a gradient color in my pivot table but I can't do it, needs to be similar to my old tableau table, my measure is: count(distinct([Unique Value])).

The top number is the red one, lowers the hue from red to gray until 0

Old tableau table

New pivot table in QlikSense

Thanks in advance!

[Almen · Accepted solution]

I don't know your measure but try something like this:

ARGB(Sum(MeasureField)/max(TOTAL aggr(Sum([MeasureField]),Priority))*256,208,0,40)

[brunobertels]

Hi 

Have a look to the colormix function in qliksense also 

[JRamos]

It worked perfectly, thanks!!!