Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

US Heat Map Help

Hello,

Looking for the best expression to cover the following:

Looking at Variance in Claims from one year to the next.  I want the higher positive numbers to show red, with the colors going towards white as they get smaller.  Conversely, I want the negative numbers as they get smaller, to get more blue.  Currently, my equation is:

If(Variance>0, LightRed(),

If(Variance<=0, Blue(),))

Any ideas on the best equation to get the smallest numbers to come in the most blue?

Here is my map currently:

heat map.png

New York and the white states should be the darkest blue possible.

Thank you!

0 Replies