Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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
Highlighted
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...

Highlighted
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

Highlighted
Champion II
Champion II

Capture.PNG

Highlighted
Partner
Partner

Try Colormix()

Highlighted
Creator II
Creator II

Thank you Vineeth. It worked perfectly.

Jeff

Highlighted
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

Highlighted
Partner
Partner

Refer

Color Themes with ColorMix.qvf

It has example attached.