This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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 .
With this files the Loadscript looks like
@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
(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
you could try loading the geonames.org Postal code files (GeoNames) with QlikView and doing the mapping yourself (download GB.zip for uk postcodes).
\Thanks both this was really helpful