QlikView App Dev

[paullawrence190]

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

[m_s]

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 · Accepted solution]

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]

\Thanks both this was really helpful