Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

where can I find the latitude and longitude?

Hello,

I have download the google maps extension (How to add the Google Maps extension objects in QlikView - YouTube)for to show google maps in qlikview.

I have found on the internet code and that is:

CustomerTable:

LOAD Quantity,

     Customer,

     City

FROM

C:\Users\Name\Documents\Qlikview\prototype2\Customer_info.xls

(biff, embedded labels, table is [Sheet1$]);

let noRows = NoOfRows('CustomerTable')-1;

for i=0 to $(noRows)

    let a = peek('Customer',$(i),'CustomerTable');

    let b = peek('City',$(i),'CustomerTable');

    let c = peek('Quantity',$(i),'CustomerTable');

      

    GeocodeResponse:

    LOAD

    status,

    '$(a)' as CustomerName,

    '$(b)' as CustomerCity,

    '$(c)' as CustomerQuantity,

    ([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;

when I use this google maps work.

In the excel sheet is the column: city, these city shows in google maps.

But where can I find the latitude and longitude, so I can add/delete city?

thanks in advance.

0 Replies