GeoQLik Locations GB and General

[tm_]

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

[rbartley]

Hi,

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

[rbartley · Accepted solution]

Have you seen this post?

https://community.qlik.com/t5/Qlik-Sense-App-Development/Association-of-maps-with-postal-code/m-p/59...

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