Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

google maps and qlikview

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

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

thanks in advance.

0 Replies