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.
![google_maps.jpg](/legacyfs/online/84067_google_maps.jpg)
my question is: how can I get the longitude and the latitude in the box 'maps'?
thanks in advance.