Linking Postal Codes with Adm1, Adm2, Adm3 (DE)

[Sarkunelis]

Hi everyone,

I am facing an issue regarding DE geographical data. I have successfully loaded from QGA and connected adm1 and adm3 info, but I can't figure out how to connect ZIP information to them.

When I load just the ZIP Table, I get all distinct  ZIP values, but these two fields are completely empty: Dataset_Adm1Code, Dataset_Adm2Code. I don't see any fields in a dataset which could be used for linking.

Can it be that there are issues with underlying  QGA data?

[Patric_Nordstrom · Accepted solution]

@Sarkunelis  zip codes doesn't necessarily follow the administrative boundaries. A zip code area is a thought area that bounds addresses of a zip code together, from the beginning the area a single postman could cover.  In many countries the zip codes live there own life.

However it is possible to construct hierarchies using the GeoAnalytics operator IntersectsMost.

See this tutorial:

https://community.qlik.com/t5/Qlik-GeoAnalytics-Documents/Mapping-Postal-codes/ta-p/1586891

Thanks,

Patric