topic Re: Geoanalytics Map with zip code of customized territory in GeoAnalytics

Geoanalytics Map with zip code of customized territory

qliksus — Wed, 29 Jan 2025 15:33:40 GMT

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?

Re: Geoanalytics Map with zip code of customized territory

paolo_cordini — Mon, 10 Jan 2022 07:31:32 GMT

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/1753980

Regards
Paolo

Re: Geoanalytics Map with zip code of customized territory

Patric_Nordstrom — Mon, 10 Jan 2022 10:41:41 GMT

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/GeospatialFunctions/GeoGetPolygonCenter.htm

Re: Geoanalytics Map with zip code of customized territory

qliksus — Mon, 10 Jan 2022 11:55:09 GMT

Thank you , will check update you soon.

Re: Geoanalytics Map with zip code of customized territory

qliksus — Mon, 10 Jan 2022 11:56:22 GMT

Thank you for the guidance to get the CenterPoint.

Re: Geoanalytics Map with zip code of customized territory

qliksus — Tue, 11 Jan 2022 10:01:08 GMT

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.

Re: Geoanalytics Map with zip code of customized territory

paolo_cordini — Tue, 11 Jan 2022 10:26:25 GMT

which error do you get?

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

Re: Geoanalytics Map with zip code of customized territory

qliksus — Tue, 11 Jan 2022 11:13:03 GMT

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.

Re: Geoanalytics Map with zip code of customized territory

paolo_cordini — Tue, 11 Jan 2022 11:32:33 GMT

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

Re: Geoanalytics Map with zip code of customized territory

qliksus — Tue, 11 Jan 2022 11:41:15 GMT

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.

Many thanks in advance.

Re: Geoanalytics Map with zip code of customized territory

qliksus — Wed, 12 Jan 2022 05:28:09 GMT

Much appreciated, Thank you .

Will it work if i split the single table into two tables as in below .

T1: REGION_ID, DISTRICT_ID, TERRITORY_NUMBER, VALUE

T2: TERRITORY_NUMBER, ZIPCODE, COUNTRY

In the operation , what should be the input for "Loaded Table Name ", "Key" since the REGION_ID& ZIPCODE both are in different tables not in a single table and we want to dissolve based on the field "REGION_ID".

Many thanks in advance

Re: Geoanalytics Map with zip code of customized territory

paolo_cordini — Thu, 13 Jan 2022 07:46:55 GMT

this should be the connector configuration in your case:

Regards

Paolo