This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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.
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
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...
Thank you Vineeth. It worked perfectly.
Thanks Shraddha, I'll have to check that out. I'm not familiar with ColorMix().
Can you point to any good examples?
Color Themes with ColorMix.qvf
It has example attached.