Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
rathnam_qv
Creator
Creator

Google Map

Hi All,

i am trying to implement the Map but, i am facing one proble...please see the following code

Table1:

LOAD FirstName,

     LastName,

     ProductSold,

     City

FROM

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

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

for i=0 to $(noRows)

    let a=peek('FirstName',$(i),'Table1');

       let b=peek('LastName',$(i),'Table1');

       let c=peek(‘ProductSold’,$(i),'Table1');

    let address=peek('City',$(i),'Table1');   

  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 

and see the error in the attached image

can anyone help me out.

Regards,

Rathnam.

4 Replies
tresesco
MVP
MVP

Try to access your URL from outside. Is it working? Probably not, hence you get the error message.

rathnam_qv
Creator
Creator
Author

then how to resolve it?

tresesco
MVP
MVP

Login here: https://code.google.com/apis/console and get your own APIKey, that should help.

adarsh_a
Contributor III
Contributor III

Hi all,

I'm also getting the same error when I try to implement google maps.Can anyone tell the reason for this?

I got key for Google Maps JavaScript API v3 access