Color Qlik map with condition

[Pragya]

Hi All, 

I am trying to create a incidence map in Qlik. 

Steps I took are, I chose Map from Chart. Added area layer. Added area dimension [show.Area] from the KML file. 

In location tab, I added 

 - If (Count(distinct people)/sum (Population)*100000 > 0, [show.Area] )

I want to color the map on the condition that incidence should be > 0 and less than 2000. The formula i wrote is

In color, I chose color by measure. Then I added 

If ((Count(distinct people)/sum (Population) *100000 > 0)
and (Count(distinct people)/sum (Population) *100000 < 2001 ),Count(distinct people)/sum (Population) *100000)

This formula works fine in the table chart but does not color the map. Could someone suggest what is wrong in the above formula?

Thanks beforehand. 

[vikasmahajan]

hi,

Did  you try with color with expression

Vikas

[Pragya]

Yes i did. The map is grey. 

When i write 

If (Count(distinct people)/sum (Population) *100000 > 0 ,Count(distinct people)/sum (Population) *100000) , map colors fine. 

When i write 

If ((Count(distinct people)/sum (Population) *100000 > 0)
and (Count(distinct people)/sum (Population) *100000 < 2001 ),Count(distinct people)/sum (Population) *100000) , map goes grey