Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
theboss-123
Creator II
Creator II

Load Data Google Maps for beguinner

Hello ,

following the guide 

Document preview of Steps to Implement Google Map in Qlikview.docx

when i try to load data i got erros  "symantic erro
for i=0 t"

my script is bellow :

Customer_info:
LOAD FirstName,
LastName,
City,
ProductSold
FROM
[C:\Users\secre\OneDrive\Documents\01_UNIMER GROUP\12_WORK QLIKVIEW\work a valider\Left Join\Google Maps LAB\Customer_info.xls]
(biff, embedded labels, table is Sheet1$);

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

for i=0 to $(noRows)

let a=peek('FirstName',$(i),'Customer_info');
let b=peek('LastName',$(i),'Customer_info');
let c=peek(‘ProductSold’,$(i),'Customer_info');
let address=peek('City',$(i),'Customer_info');

Data:
LOAD
'$(a)' as FirstName,
'$(b)' as LastName,
'$(c)' as ProductSold,
'$(address)' as Address,
subfield([Response/Placemark/Point/coordinates], ',' ,1) AS longitude,
subfield([Response/Placemark/Point/coordinates], ',' ,2) AS latitude
FROM [http://maps.google.com/maps/geo?q=$(address)&output=xml&oe=utf8&sensor=false&key=XXYYZZ] (XmlSimple, Table is [kml]);

next

1 Reply
theboss-123
Creator II
Creator II
Author

i updated the script but now i got error

theboss123_0-1635862598336.png