Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.
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.
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.
Hi Ashalatha,
Use this expression:
if(Sum([cb_2014_34_cousub_500k.Area]) < 35001, rgb(255,0,0),rgb(146,2018,80))
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