7 Replies Latest reply: Jul 12, 2016 8:50 AM by Roman Spyridis RSS

    Google Maps in QV

    Roman Spyridis

      Hi guys,

       

      I have looked online for some help on how to create a dashboard with containing some Google Maps in it but as you've guessed I've failed. It seems that none of the examples I've found wouldn't work at all.

      Basically what I am trying to do is upload an Excel file with 3 columns (Name, Status and City) into QlikView. The Name field is for our customers, Status is if they are active of Inactive customers and City is the place they belong. What i wanna do is having a map of UK showing all our customers in the relevant city and depending on their status i want the name to show Green if they are active or Red if inactive. Now i have used the script below that I've found online but QlikView give's me an error message. Please see below the script and the attachment.

       

      Thanks in Advance

       

      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