

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
\Thanks both this was really helpful
