Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Heat Map Color Controlled by Data's Rank

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

1 Solution

Accepted Solutions
Champion II
Champion II

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)

)

View solution in original post

7 Replies
Creator II
Creator II

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

Champion II
Champion II

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)

)

View solution in original post

Champion II
Champion II

Capture.PNG

Partner
Partner

Try Colormix()

Creator II
Creator II

Thank you Vineeth. It worked perfectly.

Jeff

Creator II
Creator II

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

Can you point to any good examples?

Jeff

Partner
Partner

Refer

Color Themes with ColorMix.qvf

It has example attached.