topic Re: Google Maps in QV in QlikView

Google Maps in QV

Anonymous — Wed, 06 Jul 2016 13:28:52 GMT

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

Re: Google Maps in QV

Anonymous — Wed, 06 Jul 2016 14:34:42 GMT

Re: Google Maps in QV

Anonymous — Wed, 06 Jul 2016 14:57:21 GMT

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

Re: Google Maps in QV

Anonymous — Fri, 08 Jul 2016 08:12:59 GMT

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

Re: Google Maps in QV

Anonymous — Fri, 08 Jul 2016 12:30:48 GMT

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

Re: Google Maps in QV

dmac1971 — Fri, 08 Jul 2016 13:25:59 GMT

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.

Re: Google Maps in QV

Anonymous — Tue, 12 Jul 2016 12:50:28 GMT

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

Re: Google Maps in QV

Anonymous — Tue, 12 Jul 2016 12:50:49 GMT

Thanks. I ll see how it's going