Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
jmonroe918
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
vinieme12
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
jmonroe918
Creator II
Creator II
Author

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

vinieme12
Champion II
Champion II

Capture.PNG

shraddha_g
Partner
Partner

Try Colormix()

jmonroe918
Creator II
Creator II
Author

Thank you Vineeth. It worked perfectly.

Jeff

jmonroe918
Creator II
Creator II
Author

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

Refer

Color Themes with ColorMix.qvf

It has example attached.