Creating a map with partner's and customers longitude/latitiude pictured by levels of turnover

[#1]

Hello,

there is the following problem:

I have to create a map, which shows the customers and our partners ( the size of the points reflect the revenue of the customers/partner)

For the partner I have to generate the longitude/latitude with google =>I copied the instruction  from a discussion here in Qlik View community but it doesn't work!

The longitude and latitude for our customers: I get it from the QVD!

For a better understanding I add the instruction to create the partners longitude/tatitude:

Partner:

LOAD FirstName as Name,

     Address,

     State,

     City as Ort,

     Umsatz*-1 AS Umsatz

FROM

Partneradressen.xlsx

(ooxml, embedded labels, table is Tabelle1);

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

for i=0 to $(noRows)

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

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

    //let address=peek('Address',$(i),'Table1') & ' ' & peek('City',$(i),'Table1') & ' ' & peek('State',$(i),'Table1');   

//Concatenate(Partner)

Data:

    LOAD

    //'$(d)' as Name,

    '$(address)'as Ort,

    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

    Hoping someone can help me!

Greetings

Stefanie