Heat Map Customize Color

[AJAA]

Hi There,

This may be a silly question, I am trying to create my first Heat Map for sales growth and has been asked to customize ranges and colors. I have created the Heat Map, but can't find a way to customize color based on only 3 ranges:

0 to 3% Amber

3% up Green

Less than 0% Red

Thanks

[Alan_Slaughter]

Hi Ajaa, I will reach out to my team to see if this is possible.

[vikasmahajan]

use following expression 

ColorMix1( hrank(total column(1))/NoOfColumns(TOTAL) , lightgreen(),lightred()) in background color expression.

for e.g

[AJAA]

Hi Vikasmahajan,

Thanks for your quick response, your answer is great using pivot table, which gave me the idea to change my heat map.  Definitely I didn't clarify that I was using the "Heat Map Chart" under Custom Objects, Qlik Visualization bundle, wondering if there is a way to change colors  by ranges using "Heat Map Chart"

[Alan_Slaughter · Accepted solution]

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Visualizations/Map/map-p...