US Heat Map Help

Anonymous — Tue, 07 Jun 2016 20:00:01 GMT

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:

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

Thank you!

topic US Heat Map Help in QlikView

US Heat Map Help