Cannot get postal code lookup to work outside the ... - Qlik Community

kevinpintokpa · ‎2017-06-23

Hi all,

I have started to work with postal codes in Qlik GeoAnalytics 5.8.1 using QlikView, but cannot get them to work outside the US.

In the US, a lookup using a composite field of Postal Code, State Code, Country Code works, e.g.

78749, TX, US

I can use this in both Bubble and Area layers.

Outside the US, I have tried several options and neither work in either Bubble or Area layers:

Canada:

H1B 5A1, QC, CA

H1B 5A1, QC, CA:XPC

H1B5A1, QC, CA

H1B5A1, QC, CA:XPC

The same results apply to any non-US country.

What does work to some degree:

Montreal, QC, CA (in the Bubble layer)

But of course, the resolution of the postal codes is lost.

Perhaps I am doing something wrong. Any suggestions are appreciated.

Anonymous · ‎2017-06-26

Try using named area lookup with just the pincode in the field. Select the country code in the connector popup. It worked for India in my case.

Patric_Nordstrom · ‎2017-06-26

Hi Kevin,

Zip code, country code and typ code is the prefered way: ='H1B,CA:XPC'

The coverage varies country by country, in Canada the zip code areas are of three digit resolution.

Fr more tips on specifying locations, check out my answer here:

Thanks,

Patric Nordström

Qlik

kevinpintokpa · ‎2017-06-26

Thanks for the suggestion. Unfortunately I have a global map with over 100 countries, so I can't fix the map to just one country.

Cannot get postal code lookup to work outside the US