topic Re: Simple mapping tool for UK postcodes in QlikView

Simple mapping tool for UK postcodes

paullawrence190 — Wed, 25 Nov 2020 16:16:04 GMT

Does anyone know of a simple mapping tool for qlik that uses UK postcodes.

I have used goole maps in the past with long and lat but dont have those in this set of data.

Just wondered if there was a app or product out there even if have to pay for that allows simple mapping of reference points .

Thanks

Paul

m_s — Wed, 08 Nov 2017 11:24:44 GMT

Hello Paul,

you could try loading the geonames.org Postal code files (GeoNames) with QlikView and doing the mapping yourself (download GB.zip for uk postcodes).

Mathias

Ralf_Heukäufer — Wed, 08 Nov 2017 14:19:10 GMT

With this files the Loadscript looks like

LOAD

@1 AS Country,

@2 AS postcode,

@3 AS place,

@4 AS "federal state",

@5 AS "federal statel contruction",

@8 AS district,

'[' & @11 & ','& @10 &']' as geocoordinates

FROM [lib://Qlik/allCountries.txt]

(txt, utf8, no labels, delimiter is '\t', msq);

TAG FIELDS geocoordinates WITH $geopoint;

You must only change the Folder and the txt name in the From clause

paullawrence190 — Thu, 16 Nov 2017 09:32:53 GMT

\Thanks both this was really helpful