Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
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