topic Re: Heat Map Color Controlled by Data's Rank in QlikView

Heat Map Color Controlled by Data's Rank

jmonroe918 — Wed, 15 Nov 2017 00:57:13 GMT

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

Re: Heat Map Color Controlled by Data's Rank

jmonroe918 — Wed, 15 Nov 2017 01:11:46 GMT

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...

Re: Heat Map Color Controlled by Data's Rank

vinieme12 — Wed, 15 Nov 2017 08:15:03 GMT

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)

)

Re: Heat Map Color Controlled by Data's Rank

vinieme12 — Wed, 15 Nov 2017 08:22:03 GMT

Re: Heat Map Color Controlled by Data's Rank

shraddha_g — Wed, 15 Nov 2017 08:33:11 GMT

Try Colormix()

Re: Heat Map Color Controlled by Data's Rank

jmonroe918 — Wed, 15 Nov 2017 16:01:48 GMT

Thank you Vineeth. It worked perfectly.

Jeff

Re: Heat Map Color Controlled by Data's Rank

jmonroe918 — Wed, 15 Nov 2017 16:03:11 GMT

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

Can you point to any good examples?

Jeff

Re: Heat Map Color Controlled by Data's Rank

shraddha_g — Wed, 15 Nov 2017 16:05:12 GMT

Refer

Color Themes with ColorMix.qvf

It has example attached.