Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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
Highlighted
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

Highlighted
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

Highlighted
Contributor
Contributor

\Thanks both this was really helpful