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)
11 Replies
qliksus
Specialist II
Specialist II
Author

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

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