Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
)
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...
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)
)
Try Colormix()
Thank you Vineeth. It worked perfectly.
Jeff
Thanks Shraddha, I'll have to check that out. I'm not familiar with ColorMix().
Can you point to any good examples?
Jeff