topic Another Google Maps Extension in QlikView

Another Google Maps Extension

Alexander_Thor — Mon, 26 Jan 2026 16:26:21 GMT

UPDATE 2013-03-23

It's great to see the support from the community around mapping! This thread has been great to follow and lots of fun contributions has been added.

It has however become quite crowded with different versions being discussed and it's hard to find any useful information anymore.

So I have decided to kill off this thread and at the same time I have updated the extensions and split them into 3 parts with each extension having it's own thread.

Hopefully this will make it a bit easier to find information, ask questions and share new implementions of the extension between each other.

Google Maps - Cluster

http://community.qlik.com/message/325640

Google Maps - Marker

http://community.qlik.com/message/325641

Google Maps - Heatmap (New!)

http://community.qlik.com/message/325642

If there is interest for a more collaborative development let me know and I will host the extensions up on Git.

Message was edited by: Alexander Karlsson

Another Google Maps Extension

Wed, 28 Sep 2011 20:31:32 GMT

Well done Alexander !

Maybe you should put your example in the share qv section

regards

Another Google Maps Extension

Wed, 28 Sep 2011 20:53:56 GMT

Just a question to understand well.

How can I center and zoom the map on my selection ?

Can I Use the variables var_mid_Lat, var_mid_Long, var_zoom directly in the javascript file ? and how ?

Thanks

Another Google Maps Extension

Alexander_Thor — Mon, 03 Oct 2011 11:02:23 GMT

Sorry for not getting back to you earlier.

The QV script that has been floating around for static map integrations is not used for this extension.

I have not exposed those settings in the properties dialog but if you open up the script.js file you can modify this line to define your map center:

var center = new google.maps.LatLng(59.315605, 17.951835);

A few lines below you can also fine tune the intial zoom level if you like. Or specify a different map if you like, I went with a roadmap but you could tweak it to show a satelite map if you like.

Another tweak that you might want to do is to tweak the grid size that determains when the pins should be "grouped" or not.

Change the line, var mcOptions = {gridSize: 30, maxZoom: 15};, to suit your needs.

I have also included a sample function to build your own marker text. Now it shows the number of items in the cluster, but you might want it to show for example average sale size in the cluster and so forth.

For this specific client we built a function so they could switch between different metrics on the markers, for example average sale, number of customers and so forth.

And sorry for the leangthy answer

Another Google Maps Extension

Mon, 03 Oct 2011 18:38:03 GMT

Thanks Alex for your answers.

I have seen the script in js file.

My question was to know if it's possible to replace lat/long in the formula :

var center = new google.maps.LatLng(59.315605, 17.951835);

with coordinates calculated from your selection, ie, the 2 variables var_mid_Lat(Long) which are calculated in QV.

Same question with the zoom.

Regards and thanks again for your effort

Another Google Maps Extension

Alexander_Thor — Mon, 03 Oct 2011 19:34:07 GMT

Valid point since I redraw the map for each data update, probably should not do that

And no, I am not sure. The only way I have found to reference a variable is through a input box so far.

Anyone else has any insights on this?

Another Google Maps Extension

Alexander_Thor — Tue, 08 Nov 2011 22:45:03 GMT

Updated orginal post and version of the extension. Please update any old versions floating around out there.

Another Google Maps Extension

Thu, 17 Nov 2011 14:20:19 GMT

Hello,

How I can put a description in the location? In your example, you load lat,lng and Desc, but how can I show a Desc?

Thanks,

Alessandro Furtado

Another Google Maps Extension

Wed, 23 Nov 2011 15:45:24 GMT

Hot stuff

Another Google Maps Extension

sukydhak — Thu, 15 Dec 2011 22:34:04 GMT

Alex

This looks cool. If I select the data in the list object the values change as expected but does not work if i select the pointers from within the map.

Is that possible?

Suky

Another Google Maps Extension

Alexander_Thor — Thu, 15 Dec 2011 23:05:59 GMT

Yes, you could add an onclick event to the both the cluster markers and the actual pushpin.

However since Google has decided to charge quite a hefty license fee to put anything built on Google Maps API into production this sort of killed my motivation to give this extension any more love

I will be making something similar for openstreetmap, it's free!, as soon as I get some spare time.

Re: Another Google Maps Extension

Fri, 16 Dec 2011 06:11:19 GMT

Hi,

This is not working in my machine. can u tell me what might be the reason.

Another Google Maps Extension

Thu, 09 Feb 2012 16:06:34 GMT

Hi,

Very cool extension!

Once I've tried changed var center = new google.maps.LatLng(-31.503629, 145.546875) but once I've done that, your exemple does not seem to work anymore...

Any idea why?

Another Google Maps Extension

Thu, 09 Feb 2012 16:32:39 GMT

Ok you just need to add double quotes to the values.

Regards,

Bastien.

Another Google Maps Extension

Thu, 09 Feb 2012 19:16:16 GMT

These 2 functions can be used in order to automatically center your maps and set the appropraite zoom level.

//Centers the map and fits the appropriate zoom

map.setCenter(latlngbounds.getCenter());

map.fitBounds(latlngbounds);

It works by first creating the variable

var latlngbounds = new google.maps.LatLngBounds();

and then whilst you are handling you data you pass the lat and long values into the object to create an array of the co-ordinants.

latlngbounds.extend(new google.maps.LatLng(lat, longi));

Once you have that done the 2 functions at the top can be used to centre and zoom. All you need to do is use the 2 functions outside of your data handling loop

Its all documented in the Google Map v3 API guide

http://code.google.com/apis/maps/documentation/javascript/reference.html

Lewis

Re: Another Google Maps Extension

Tue, 14 Feb 2012 09:49:40 GMT

Lewis,

Would you be so kind to share a .js example of that? I'm still trying to get my head around javascript.

And if somebody has a working example of how to use the onclick function, this is the furthest I got:

google.maps.event.addListener(marker, 'click', function() {

this.Document.Data.SelectTextsInColumn(23, false, "value");

});

I can get it working if I use an google infobox, then you click on the pin and a google infobox appears but that was the most magic I got to work.

Thanks

Edit: forget about the autocenter, I finally got it working

The code (there are probably 10 things that could be done more efficiently):

function Map_Done() {

Qva.AddExtension("TestMap",

function() {

//Check for existing map canvas.

if (this.Element.children.length == 0) {

var ui = document.createElement("div");

ui.setAttribute("id",divName);

ui.setAttribute("style","width: 100%; height: 100%");

this.Element.appendChild(ui);

}

//Define Map center

var center = new google.maps.LatLng(50.8503396,4.3517103);

var latlngbounds = new google.maps.LatLngBounds();

//Draw map - Change options to suit your needs.

var Map = new google.maps.Map(document.getElementById(divName), {

zoom: 2,

center: center,

mapTypeId: google.maps.MapTypeId.ROADMAP

});

var markers = [];

//Create markers (cluster array removed, each marker is created individually).

for (var i = 0; i < this.Data.Rows.length; i++) {

var row = this.Data.Rows ;

var latLng = new google.maps.LatLng(row[0].text,row[1].text);

var Country = row[2].text;

var marker = new google.maps.Marker({

position: latLng,

map: Map

});

markers.push(marker);

latlngbounds.extend(new google.maps.LatLng(row[0].text,row[1].text));

}

var mcOptions = {gridSize: 15, maxZoom: 11};

var markerCluster = new MarkerClusterer(Map, markers, mcOptions);

Map.setCenter(latlngbounds.getCenter());

Map.fitBounds(latlngbounds);

var listener = google.maps.event.addListener(Map, "idle", function() {

if (Map.getZoom() > 16) Map.setZoom(16);

//google.maps.event.removeListener(listener);

});

};

Re: Another Google Maps Extension

Thu, 23 Feb 2012 15:42:17 GMT

Hi,

I took liberty of modifying the script, so it's more to what I need.

Changes:

+ placemarks have Measure as tooltip

+ circles (at placemark coordinates) scaled according do Measure

+ circle color is random

+ map type is hybrid or road map (hybrid by default)

- commented out Marker Cluster (does not work with circles added)

What I cannot make work and I'd appreciate some help:

1) I would like to add another measure which would be a placemark tooltip, but however I modify Definition.xml and Properties.qvpp - I can't get it working; neither adding a dimension or measure works for me.

How are variable names defined in Properties.qvpp (where do these ".Chart.Dimension.1.Field" come from?).

2) I tried to refactor a code a bit to be able to scale circles according to zoom level, but calling any script function from Map_Done just does not work...

Another Google Maps Extension

Sun, 26 Feb 2012 15:41:05 GMT

Hey, this extension is really cool but it is not working for me My guess is that we use different decimal separator (we use comma instead of point). Could it be the reasom? How can i fix it?

Thanks,

Migle

Another Google Maps Extension

Alexander_Thor — Mon, 27 Feb 2012 08:44:39 GMT

Nice job! Amazing that a simple proof of concept can spawn such creativity amongst the community.

Are you running v11? The properties and definition files are alot simpler to work with from v11 and onwards.

You should be able to call outside functions within map_done, I'll check if I can get you a working sample.

Another Google Maps Extension

Mon, 27 Feb 2012 20:51:11 GMT

I'm at v11.

As for props + defs: I think I'll open another thread, as I cannot find a developer documentation for extensions feature (there are multiple examples, but I can't get grammar definition etc.).

javascript function calls: I tried to put a loop creating points+circles as separate function (basic refactoring), so I could use map resize listener to rescale circles. To my best knowledge refactoring was ok, no errors thrown, but no output either - gmaps just zooms out to "Earth" level and no points are added.

BR,

Bart