Heat Map Color Controlled by Data's Rank

[jmonroe918]

I have  simple Heat Map where I am showing quantities by brand and want to show the top 3 (highest to lowest) in Red, Orange and then Yellow respectively. I would then like to show the rest of the maps tiles as differing shades of grey (if possible).

I've attached a sample of my qvw.

Thanks

Jeff

[jmonroe918]

I was trying a background color expression something like this but it's getting errors:

=if(Rank(-(sum([Brochures.Total Qty Required])>2, red(), yellow()))) 

Just as a start...

[vinieme12 · Accepted solution]

try below

<<EDITED>>

if(rank(sum([Brochures.Total Qty Required]),1,1)<=3,Pick(rank(sum([Brochures.Total Qty Required]),1,1),red(),LightRed(),yellow())

,

argb(255/rank(sum([Brochures.Total Qty Required]),1,1),0,0,0)

)

[vinieme12]

[shraddha_g]

Try Colormix()

[jmonroe918]

Thank you Vineeth. It worked perfectly.

Jeff

[jmonroe918]

Thanks Shraddha, I'll have to check that out. I'm not familiar with ColorMix().

Can you point to any good examples?

Jeff

[shraddha_g]

Refer

Color Themes with ColorMix.qvf

It has example attached.