google maps and qlikview

Sun, 19 Apr 2015 13:37:52 GMT

hello,

I have a question. I use the google maps extension, but it doesn't work. (see below by maps) I have load the latitude and the longitude in a exel file into qlikview.

my code is:

google:

LOAD id,

outcode,

lat,

lng

FROM

lat_lng.xlsx

(ooxml, embedded labels, table is lat_lng);

let noRows = NoOfRows('google');

for i=1 to $(noRows)

let a = peek('lat',$(i),'google');

let b = peek('lng',$(i),'google');

let c = peek('outcode',$(i),'google');

let d = peek('id',$(i),'google');

GeocodeResponse:

LOAD

status,

'$(a)' as lat,

'$(b)' as lng,

'$(c)' as outcode,

'$(d)' as id,

([result/geometry/location/lat]) as latitude,

([result/geometry/location/lng]) as longitude

FROM [http://maps.googleapis.com/maps/api/geocode/xml?address=$(b)&sensor=false] (XmlSimple, Table is [GeocodeResponse]);

next i;

In the properties of the extension (right click) I have by latitude: lat and by longitude: lng; so you can see.

my question is: how can I get the longitude and the latitude in the box 'maps'?

thanks in advance.

topic google maps and qlikview in QlikView

google maps and qlikview