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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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.

Labels (1)
4 Replies
tresB
Champion III
Champion III

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?

tresB
Champion III
Champion III

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