Discussion Board for collaboration regarding Qlik GeoAnalytics.
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?
this should be the connector configuration in your case:
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:
To get a centerpoint you can use GeoGetPolygonCenter() function on the generated areas from the Dissolve operation.
Thank you , will check update you soon.
Thank you for the guidance to get the CenterPoint.
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.
which error do you get?
I tried with your app but I don't get any error.
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.
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.
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.