Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
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

1 Solution

Accepted Solutions
Ralf_Heukäufer
Partner
Partner

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
Partner

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
Partner

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

paullawrence190
Contributor
Contributor
Author

\Thanks both this was really helpful