Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
paullawrence190
Contributor
Contributor

Simple mapping tool for UK postcodes

Hi

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

Labels (1)
1 Solution

Accepted Solutions
Ralf_Heukäufer
Partner - Creator III
Partner - Creator III

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

View solution in original post

3 Replies
m_s
Partner - Creator II
Partner - Creator II

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
Partner - Creator III
Partner - Creator III

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
Contributor
Contributor
Author

\Thanks both this was really helpful