Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qliksus
Specialist II
Specialist II

Geoanalytics Map with zip code of customized territory

Hi Team,

We have two tables , one is having Country, District, Territory, Value and the other one is having the Teritory & Zipcode mapping. Since the key field Territory is a customized as per the organization we are struggling the define boundary in area map based on zipcode. Basically  we are trying to create a area & bubble layer using the US zipcode mapped to territory. Can it achieved  using the Open Street Map or Geoanalytics Connector? 

Fyi.. i have attached the sample zipcode, could any please suggest?

 

 

 

Labels (1)
1 Solution

Accepted Solutions
paolo_cordini
Partner - Contributor III
Partner - Contributor III

Hi

this should be the connector configuration in your case:

2022-01-13_08h45_36.png

Regards

Paolo

View solution in original post

11 Replies
paolo_cordini
Partner - Contributor III
Partner - Contributor III

Hi,

for the area map you should use the "Dissolve" Geoanalytics connector operation, which merges areas  according to a grouping dimension (Territory in you case).

For bubble layer it is a little bit more tricky, because you don't have a single coordinate point for the "Territory" dimension. Maybe you could use the "Cluster" operation to get a single centroid point among the ZIPs pertaining to a territory.

You can find examples of both operators here:

https://community.qlik.com/t5/Qlik-Sense-Documents/GeoOperations-Examples-Qlik-GeoAnalytics/ta-p/175...

Regards
Paolo

Patric_Nordstrom
Employee
Employee

To get a centerpoint you can use GeoGetPolygonCenter()  function on the generated areas from the Dissolve operation.

 

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/GeospatialFunc...

 

qliksus
Specialist II
Specialist II
Author

Thank you , will check update you soon.

qliksus
Specialist II
Specialist II
Author

Thank you for the guidance to get the CenterPoint.

qliksus
Specialist II
Specialist II
Author

Hi Patric &Paolo,

I have tried to create a customised area for Region based on territory mapped with zipcode of US using the operation 'Dissolve' ,but its throwing me the error. Could you please help me to guide me in the right direction?

I have attached the ZIP having Excel data & Qvf file. 

Many thanks in advance.

paolo_cordini
Partner - Contributor III
Partner - Contributor III

Hi

which error do you get?

I tried with your app but I don't get any error.

 

qliksus
Specialist II
Specialist II
Author

Thanks Paolo for quick response. Actually nothing is plotted in the area layer where i used the Region_Id but able to see data points in bubble layer using the zipcode. Basically i am expecting to see 4 area for 4 different RegionId in the rea layer respectively.  Many thanks in advance.

BlankArea.PNG

paolo_cordini
Partner - Contributor III
Partner - Contributor III

Hi

please find enclosed my version, which seems to be working as desired (I checked only the area layer)

The map takes some time to show up because I added the ZIP level for verifying the correctness.

You can see how I configured the connector operation, it is slightly different.

Regards

Paolo

 

qliksus
Specialist II
Specialist II
Author

Actually i am looking something  as in the below picture. Below picture is showing area for each state, similarly i am looking for customized area for each Region based on the zipcodes. Let me know do i need to modify or need additional information to get the desired output.

State_AreaLayer.PNG

Many thanks in advance.