topic Re: Google Maps API in QlikView

Google Maps API

Anonymous — Wed, 12 Oct 2011 14:10:41 GMT

Hello,

I was looking some QV Dashboards and I found that I can insert a map with some information inside. How can I add this kind of object and associate the places with the information?

If anyone has a demo or some code, please let me know.

That will be great.

Thank you very much.

Re: Google Maps API

Sokkorn — Thu, 13 Oct 2011 07:43:06 GMT

Hi Juan,

To make this happen first you need coordinates (longitude / latitude) for your location.

See the sample attached file.

Regards,

Sokkorn

Google Maps API

Anonymous — Thu, 13 Oct 2011 14:42:25 GMT

Hi Sokkorn,

I'm running at this time the Personal Edition so I can't open that example. I was looking at the table and I realized that I have to create something like that for Colombia.

Now, which option allows me to insert the map as well and associate it with the table

Thank you very much.

Re: Google Maps API

Sokkorn — Fri, 14 Oct 2011 00:23:20 GMT

Hi Juan,

Let check my attached file again.

Or try this

SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;($#,##0.00)';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';
//===========================================================
[Location]:
LOAD
    RowNo()    AS ID,
    Country, 
    Locations, 
    [Latitude-Degree], 
    [Longitude-Degree], 
    Latitude, 
    Longitude
FROM
[Cambodia Latitude-Longitude v002.xlsx]
(ooxml, embedded labels, table is Sheet1);
//===========================================================
// Google Maps in QlikView
// V0.85.2 - October 1st 2008  © Copyright QlikTech International AB 2008 / AES
// Google Maps Key
// get a key here http://code.google.com/apis/maps/signup.html
gmap_key = 'xx';
max_zoom_level = 17; //maximum value 17 
// Variables required for calculating map
// No need to change these
var_pi180=        '=pi()/180';
var_lat_offset=    '0';
var_long_offset = '0' ;
var_mc2=        '=256*pow(2,$(var_zoom))';
var_mc1=        '=256*pow(2,($(var_zoom)-1))';
var_mid_lat=    '=min(Latitude)+(1+var_lat_offset)*((max(Latitude)-min(Latitude))/2)';
var_mid_long=    '=min(Longitude)+(max(Longitude)-min(Longitude))/2';
var_zoom=        '=max(aggr(if(max( round(256*pow(2,(_zoom_level -1)))+( Longitude  *((256*pow(2,_zoom_level ))/360)) )-min( round(256*pow(2,(_zoom_level -1)))+( Longitude  *((256*pow(2,_zoom_level ))/360)) ) <map_size_x AND max((256*pow(2,(_zoom_level-1)))+((0.5*log((1+(sin((Latitude)*pi()/180)))/(1-(sin((Latitude)*pi()/180)))))*((-256*pow(2,_zoom_level))/(2*pi()))))-min((256*pow(2,(_zoom_level-1)))+((0.5*log((1+(sin((Latitude)*pi()/180)))/(1-(sin((Latitude)*pi()/180)))))*((-256*pow(2,_zoom_level))/(2*pi()))))<map_size_y,_zoom_level,1),_zoom_level))';
var_maptype=    '=if(isnull(only(maptype)),fieldvalue( '& CHR(39)&'maptype'& CHR(39)&', 1 ),maptype)';
map_size_x=        '640';
map_size_y=     '400';
SET HidePrefix='_' ;
// Field required for calcualting best zoom level
_zoom_level:
LOAD RecNo() AS _zoom_level AutoGenerate(max_zoom_level);
maptype:
LOAD * INLINE [
    maptype
    roadmap
    mobile
    satellite
    terrain
    hybrid];

1. Create Scatter Chart
    . Dimension
        - ID
    . Expression
        -Label1: longitude with expression =sum( round (256*pow(2,($(var_zoom)-1)))+( Longitude  *((256*pow(2,$(var_zoom)))/360)) )
        -Label2: lattitude with expression =sum(((256*pow(2,($(var_zoom)-1)))+((0.5*log((1+(sin((Latitude)*pi()/180)))/(1-(sin((Latitude)*pi()/180)))))*((-256*pow(2,$(var_zoom)))/(2*pi())))))
        - Locations // Pop_up text (no label)
2. Create List Box: maptype

Do let me know, if this one still cannot open the file.

Regards,

Sokkorn

Google Maps API

Anonymous — Fri, 14 Oct 2011 14:29:52 GMT

Hello Sokkorn,

I am not able to open the document. Meanwhile I am going to use the code that you suggested.

Google Maps API

Sokkorn — Sat, 15 Oct 2011 00:32:43 GMT

Hi Juan,

Let try my script. Don't forget take my excel file and put it together with your qvw file.

Regards,

Sokkorn

Google Maps API

Anonymous — Tue, 18 Oct 2011 20:02:17 GMT

Hello,

I was trying to use the code, I have my Excel sheet with Colombia's coordinates but I don't have any Google Maps API Key.

Is that necessary?

Google Maps API

Tue, 18 Oct 2011 20:09:09 GMT

No more necessary, just put in your key anything you want !

Re: Google Maps API

Anonymous — Tue, 18 Oct 2011 20:25:11 GMT

Hello,

I've done everything you told me, with all that code... but I don't have any map in my scatter chart. Why could that happen?

If you can check my app i'll be glad.

Re: Google Maps API

Sokkorn — Tue, 18 Oct 2011 23:40:33 GMT

Morning Juan,

Let check my attahced file.

Regards,

Sokkorn

Re: Google Maps API

Thu, 11 Apr 2013 16:52:59 GMT

Hi Juan,

Could you solve your problem? I'm trying to create a map with Colombia coordinates, I'm using "Steps to Implement Google Map in Qlikview" in QlikView PE, but it didn't work. I didn't get any symbol on the map. Could you help me?

Re: Google Maps API

Anonymous — Fri, 12 Apr 2013 01:43:40 GMT

Hi andreqlik,

I solved my problem and here I attach a qvw for you to check it out.

Hope it helps!

Best regards.

Re: Google Maps API

Fri, 12 Apr 2013 14:44:30 GMT

Hi Juan,

Thanks for the file but I have Personal Edition and I can't open files. Could you share your code or tell me what exactly changed for the map work?

Best Regards.

Re: Google Maps API

Wed, 30 Oct 2013 08:34:13 GMT

I am also having this problem. I am followed the steps and this is what i get. Can anyone help me?

What did i do wrong?

I cant seem to display google map.

I had used the scripts above.

Re: Google Maps API

Anonymous — Wed, 30 Oct 2013 12:56:29 GMT

In the Colors tab, look for the Frame Background. Now check Dynamic Image and in the expression paste this:

='http://maps.google.com/staticmap?center='

num(var_mid_lat, '##############', '.', ',' )

','

num(var_mid_long, '##############', '.', ',' )

'&zoom=$(var_zoom)'

'&maptype='&var_maptype

'&size='&map_size_x&'x'&map_size_y

'&key='&gmap_key & '&.jpg'

Re: Re: Google Maps API

Wed, 30 Oct 2013 13:19:15 GMT

Unfortunately still the same...

I have attached my Qlikview file. Hope you could enlighten me on how to do it step by step? as i will not be able to open your file since I am using the personal edition.

thanks much

Re: Re: Re: Google Maps API

Anonymous — Wed, 30 Oct 2013 13:36:40 GMT

In the Axes Tab, you have to modify the Static Min and Max.

X-Axis:

Static Min:

(256 * pow(2,($(var_zoom)-1))) + ( var_mid_long * ((256 * pow(2,$(var_zoom))) / 360)) - Round(map_size_x/2)

Static Max:

((256 * pow(2,($(var_zoom)-1))) + ( var_mid_long * ((256 * pow(2,$(var_zoom)))/360)) + Round(map_size_x/2)-15)

Y-Axis:

Static Min:

((256 * pow(2,($(var_zoom)-1))) + ((0.5 * log((1 + (sin(var_mid_lat * pi() / 180))) / (1 - (sin(var_mid_lat * pi() / 180))))) * ((-256 * pow(2,$(var_zoom))) / (2*pi()))) + Round(map_size_y/2))

Static Max:

=((256 * pow(2,($(var_zoom)-1))) + ((0.5 * log((1 + (sin(var_mid_lat*pi()/180))) / (1 - (sin(var_mid_lat * pi() / 180))))) * ((-256 * pow(2,$(var_zoom))) / (2 * pi()))) - round(map_size_y/2)+15)

Also te gmap_key that you where using won't plot anything. I reatached, please reload and let me know.

Re: Re: Re: Re: Google Maps API

Wed, 30 Oct 2013 14:01:38 GMT

Thanks... This is what it looks like now... what do you mean by gmap_key wont plot anything? Could you tell me where to find the gmap_key?

I cant open your qvw file, sorry, as i am working off the personal edition.... could i trouble you to explain over in text? Or can you let me know the new script?

I have amended according to what you have said.

thanks!

Re: Re: Re: Re: Re: Google Maps API

Anonymous — Wed, 30 Oct 2013 15:34:37 GMT

Attached is the qvs of the script and a xml with the object of the map.

The object you have to import it from the file menu Import/Import Document Layout. And the script from the Script Editor.. File/Open External Script File... and that will be it... let me know if that works for you.

And send me the xls of the coordinates please.

Re: Google Maps API

Sat, 02 Nov 2013 19:16:26 GMT

I am stuck with the same problem. I cant seem to get the map background. I am trying to show a map of South Africa but it just comes up blank. Please help, busy going insane!