i'm trying to show street level map in Qlik Sense.
i have city names and street names but i don't have Longitude or Latitude
i followed the following script in Qlikview to get the longitude and latitude by using city names,
it's working fine to get the longitude and latitude but when i use the same script in Qlik Sense it's not working.
Qlik Sense Script:
let noRows = NoOfRows('CustomerTable')-1;
for i=0 to $(noRows)
let b = peek('City',$(i),'CustomerTable');
'$(b)' as City,
([result/geometry/location/lat]) as latitude,
([result/geometry/location/lng]) as longitude,
(XmlSimple, table is GeocodeResponse);
not giving me the correct result.
if anyone have any idea please help me to figure out the issue.
I Used the below URL while creating the GoogleAPI Connection