Polygon map in Qlik sense

[#1]

Hi All,

I have New Jersey data please find the attached, I would like to create polygon map , But I am getting slippy map with Longitude and latitude.

Please let me know if it is possible to create polygon map with the attached data

I am trying to create map like below:

http://lwd.dol.state.nj.us/labor/lpa/industry/incpov/income.pdf

Please advise.

[brunobertels]

hi

Your data are point geolocated with X and Y as longitude and lattitude to geolocate towns.  this is not a polygon data file.

search for a KML file or desired area or country or state

Look forward for tutorial using KML file or CVS file

but first ou have to found a polygon data set of the country / state / area needed may be here

https://www.census.gov/geo/maps-data/data/kml/kml_cousub.html

Bruno

[reddy-s]

Hi Ashalatha,

As Bruno mentioned, you need a KML file or a CSV file which has the polygon information which helps the map visualisation to trace the boundaries.

[#4]

Hi Sangram thanks a lot for your help and very sorry for the delayed message.

As you advised I did the following steps:

1.Downloaded the KML file from Cartographic Boundary KML Files - County Subdivisions - Geography - U.S. Census Bureau for New Jersey and renamed cb_2014_34_cousub_500k.Name as Municipality.

2. Loaded the  Excel sheet with Municipality, Per ca-pita Income

3. Created Map Municipality as a dimention

4.Added Sum(Per ca-pita Income) as a measure.

Now, I am having issue with adding colors by Expression, I need range for colors

For Eg If Sum([cb_2014_34_cousub_500k.Area]) between 0 and 35,000 then Red

Please advise me on this.

[#5]

Hi Bruno, thanks a lot for your help and very sorry for the delayed message.

As you advised I did the following steps:

1.Downloaded the KML file from Cartographic Boundary KML Files - County Subdivisions - Geography - U.S. Census Bureau for New Jersey and renamed cb_2014_34_cousub_500k.Name as Municipality.

2. Loaded the  Excel sheet with Municipality, Per ca-pita Income

3. Created Map Municipality as a dimention

4.Added Sum(Per ca-pita Income) as a measure.

Now, I am having issue with adding colors by Expression, I need range for colors

For Eg If Sum([cb_2014_34_cousub_500k.Area]) between 0 and 35,000 then Red

Please advise me on this.

[reddy-s]

Hi Ashalatha,

Use this expression:

if(Sum([cb_2014_34_cousub_500k.Area]) < 35001, rgb(255,0,0),rgb(146,2018,80))

[brunobertels]

Hi

Not sure the map object in Qlik Sense allow color by mesure in the MAP panel Object

I see only range with a Min / Max value fields available but don't see how it works.

nethertheless it could be somethink like :

if(Sum([cb_2014_34_cousub_500k.Area])<35000,redlight())

Bruno