Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.