Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
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

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Champion II
Champion II

Re: Heat Map Color Controlled by Data's Rank

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

Re: Heat Map Color Controlled by Data's Rank

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

Re: Heat Map Color Controlled by Data's Rank

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

Re: Heat Map Color Controlled by Data's Rank

Capture.PNG

Highlighted
Partner
Partner

Re: Heat Map Color Controlled by Data's Rank

Try Colormix()

Highlighted
Creator II
Creator II

Re: Heat Map Color Controlled by Data's Rank

Thank you Vineeth. It worked perfectly.

Jeff

Highlighted
Creator II
Creator II

Re: Heat Map Color Controlled by Data's Rank

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

Re: Heat Map Color Controlled by Data's Rank

Refer

Color Themes with ColorMix.qvf

It has example attached.