Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

drromanos
New Contributor III

Google Maps in QV

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

7 Replies
drromanos
New Contributor III

Re: Google Maps in QV

Example.JPG

filip_duchateau
Contributor II

Re: Google Maps in QV

Hi,

Have tried one of these guides ?

I haven't been using Google maps myself yet, but maybe these guides could be a starting point to work with.

Step-by-Step Google Map API v3 integration

Steps for beginners to implement Google Maps in Qlikview

Google maps

drromanos
New Contributor III

Re: Google Maps in QV

Hi,

The script i;ve used is from one of those guides. What i don't understand is why QV doesn't recognise the data i've uploaded.

TBH i don't mind if it's google maps or any other mpas. As long as I have a map in there I'm happy

Thanks

filip_duchateau
Contributor II

Re: Google Maps in QV

Hi,

Try this one :

Table1:

LOAD FirstName,

    LastName,

    City,

    [Products sold] as ProductSold

FROM

Customer_info.xls

(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');

dmac1971
Contributor II

Re: Google Maps in QV

Heres the mapping working on some UK town data, you will need longtitude and latitude etc to get it to work.  Colour isn't working, but its home time so will leave that to you.  Good luck.

drromanos
New Contributor III

Re: Google Maps in QV

Sorry couldn't see the example with the mapping working. Perhaps you forgot to attach the file. Also for the longitude and latitude... does this mean I have to have to extra columns in my excel Sheet against each city?

Regards

drromanos
New Contributor III

Re: Google Maps in QV

Thanks. I ll see how it's going

Community Browser