Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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