topic GeoQLik Locations GB and General in GeoAnalytics

GeoQLik Locations GB and General

tm_ — Tue, 07 Sep 2021 21:14:32 GMT

Hello,

I am struggling with finding some addresses in general on Postal Code and Country Code. Most often they do work but I have now found that I cannot get GB to work.

For example I want to add a line layer between 9041,BE and CV21 1DZ,GB.

Is there a database where you can look what countries and postal codes are supported by GeoQlik?

BR Thomas

Re: GeoQLik Locations GB and General

rbartley — Fri, 08 Feb 2019 11:36:03 GMT

Hi,

Perhaps a silly question, but is the issue that you're using GB instead of UK?

Re: GeoQLik Locations GB and General

rbartley — Fri, 08 Feb 2019 11:58:31 GMT

Have you seen this post?

https://community.qlik.com/t5/Qlik-Sense-App-Development/Association-of-maps-with-postal-code/m-p/59113/highlight/true#M3923

Patric fromQlik responded:

Hi Alex,

Yes UK postal codes follows an own system, here's a good summary:

Postcodes in the United Kingdom - Wikipedia

QGA has support for "Area", "District" and "Sector" postal code areas for GB except Northern Ireland.

One way to parse is (given the the postcode is proper formatted with a space in the right place):

	subfield(Postcode,' ',1) & ' ' & left(subfield(Postcode,' ',2),1) AS sector,
	subfield(Postcode,' ',1) AS district,
	If(IsNum(Mid(Postcode,2,1)),Left(Postcode,1),Left(Postcode,2)) as area