Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
hi,
Did you try with color with expression
Vikas
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