topic Re: Google Maps - Cluster in QlikView

Google Maps - Cluster

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

Google Maps Extension with Cluster support.

QlikTech takes no responsibility for any code and QlikTech Support Agreement does not cover issues with this extension.

Please review Googles license agreement before you put this into production.

Introduction

This is a QlikView extension object that integrates Google Maps Javascript API V3 and a third party library called MarkerClusterPlus into QlikView.

Load a set a coordinates into QlikView and visualize them together with this extension. The clustering feature is create when you have alot of data points and needs to group/cluster them together for greater visability and performance.

The maxzoom property defines at what zoom level you want your markers clustered. The grid size property controls how big or small cluster grid size you want.

You can either use the extension 'as is' or use it as a base to further customize it to fit your needs.

Download the extension and view source code at: https://github.com/mindspank/GoogleMaps-Cluster-QV11

If you build something awesome please share it with the community!

Live long and prosper.

2015-02-15
Removed download from post, please grab the latest version from Github instead.

2014-02-03

Various fixes.

2014-01-09

There has been numerous upgrades to the extension.

Now clusters now display the value of your expression and with added support to include more information in pop-up labels.

Example grayscale styled map included.

Possibility to show only a single cluster icon style if you do not want it to scale according to the number of markers in the cluster.

2013-06-17

Added custom marker support. Now you can specify a url for an custom marker. Accepts all major image file types.

Re: Google Maps - Cluster

Mon, 25 Mar 2013 18:51:09 GMT

Hi Alex

I really need your help on this topic (http://community.qlik.com/message/325846#325846).

I am not able to get maps on the QlikView in addition I have a this complex requirement.

Can you help.... ?

Thanks

Re: Google Maps - Cluster

Jesús_Centeno — Mon, 25 Mar 2013 20:26:47 GMT

Alexander,

I only get the sample app to work in Server mode but it doesn't work in Desktop using the Web View functionality. Is this the expected behavior?

thanks,

Jesus

Re: Google Maps - Cluster

Alexander_Thor — Mon, 25 Mar 2013 20:30:52 GMT

Hmm - nope should work in desktop also.

You got IE10 installed? Do you get any errors? We use IE components for web view which currently is working less then great with IE10...

Re: Google Maps - Cluster

Jesús_Centeno — Mon, 25 Mar 2013 20:33:18 GMT

I have IE 9. May be that is the problem?

Re: Google Maps - Cluster

Alexander_Thor — Mon, 25 Mar 2013 20:36:01 GMT

Should work with IE9 - you get no errors what so ever?

I know the extension might behave a little bit funky if you load non coordinates as latitude/longitude dimensions but the attached app should work. Let me install internet explorer and test it.

Re: Google Maps - Cluster

Jesús_Centeno — Mon, 25 Mar 2013 20:54:18 GMT

Nope, just the following screen:

Re: Google Maps - Cluster

Alexander_Thor — Mon, 25 Mar 2013 21:31:05 GMT

Just installed IE9, running QV11SR1, Win7 64-bit, downloaded the attached sample and extension and it worked fine.

Try to turn of web view, remove the map, save, turn on web view and add the map again. Seen that error before with other extensions but never tracked down the root cause.

Edit: Oh and if you have UAC turned on you might need to run QV as administrator.

Re: Google Maps - Cluster

Wed, 27 Mar 2013 12:49:17 GMT

Hi Alex

I am running IE9, QV11SR2, Win 7 64-bit.

The cluster map works on the QV Client but not on the access point.

Read that it only works with AJAX Client & not IE Plugin (which is what I have selected when loading the model via the access point).

We installed the extension on the QV server as well (where the live model is) and ran the GoogleMaps - Cluster.qar with success.

When you select AJAX the object does not show at all, when you select IE Plugin the object is there but it says"unknown chart type"

Otherwise the extension works beautifully but only on the client and not on the access point. Please help if you can.

Thanx Candice

Examples below:-

Re: Google Maps - Cluster

Julie_Main — Thu, 28 Mar 2013 11:24:36 GMT

I've tested this in two app's, one it works fine, the other I get the following error (it's actually the same error and same app I have the problem with for the markers as well):

Stack Overflow at line 24

The first app is a small dataset (under 10,000), the second app is larger (about 150,000), however I have cut it down to under 10,000 and still get the error ..

Any ideas? By the way, I'm good at Quality Management as I invariably break stuff!!

Re: Google Maps - Cluster

Alexander_Thor — Thu, 28 Mar 2013 11:49:39 GMT

I havent tried it with that large dataset but I have seen the stack overflow error before, usually when u add the extension for the first time and there is no valid coordinates as a dimension. A F5 will fix that.

Is your data set clean? It could be that it snuck in some crap data amongst the coordinates that throws the stack overflow error.

If you can share the data, just email me offline, I can try to debug it.

I'll add the possibility to use custom marker icons while I'm at it. I'll do some test to see if I can validate the data input also without a too big performance hit to avoid further problems.

Kind Regards

Alexander Karlsson

28 mar 2013 kl. 12:24 skrev "jgo" <qcwebmaster@qlik.com<mailto:qcwebmaster@qlik.com>>:

QlikCommunity<http://community.qlik.com/index.jspa>

Re: Google Maps - Cluster

created by jgo<http://community.qlik.com/people/jgo> in Integration and Extensions - View the full discussion<http://community.qlik.com/message/327622#327622>

Re: Google Maps - Cluster

Julie_Main — Thu, 28 Mar 2013 12:07:18 GMT

Thanks Alexander .. I tried the F5 and still getting the error - also, I'm down to under 700 records .. I do have a couple of other extension objects on their .. I wonder if this is causing problems.

Ok, so have taken off ALL other extension objects, cut down data and tried again and same error .. I even cleaned the entire cache .. very strange .. especially as it's fine in my other app .. If it's ok, will send you a copy - it's something for demo.qlikview, so don't want to post it here till it's complete ;0)

Re: Google Maps - Cluster

Wed, 10 Apr 2013 05:38:32 GMT

Hi!

I have installed IE10, running QV11SR1, Win8 64-bit. In 2 apps (1 - about 1000 coordinate pairs, 2- 5 coordinate pairs).

2nd app works fine, but using 1st app I get stack errors (as jgo writes): Stack Overflow at line 24, Stack Overflow at line 25, Stack Overflow at line 27.

Do you have an opinion on the reasons?

Thanks!

Re: Google Maps - Cluster

Alexander_Thor — Wed, 10 Apr 2013 14:37:06 GMT

Hey,

Ye we found the issue. If you get emtpy rows in your data model for lat/lng that will throw the error.

I'm gonna add in default suppression of NULL rows for the dimensions and validation of the coordinates so any "crap" data is filtered out. I'll upload it later tonight for you.

Kind Regards

Alexander Karlsson

10 apr 2013 kl. 16:18 skrev "Miguel Angel Baeyens" <qcwebmaster@qlik.com<mailto:qcwebmaster@qlik.com>>:

QlikCommunity<http://community.qlik.com/index.jspa>

Re: Google Maps - Cluster

reply from Miguel Angel Baeyens<http://community.qlik.com/people/mby> in Integration and Extensions - View the full discussion<http://community.qlik.com/message/334131#334131>

Re: Google Maps - Cluster

Alexander_Thor — Wed, 10 Apr 2013 21:53:44 GMT

Updated the original post with a new version of the extension.

Now suppressing NULL rows to avoid Stack Overflow errors. The extension will still throw an error if you have coordinate pairs that's not valid, i.e bad data quality.
Added an option to allow popup windows when you hover over an marker. The value in the infowindow is controlled by your expression. You can style the contents by regular html tags. Example:

='<B>Total Number of Visits: </B>' & Sum(CountVisit) & '<img src="http://www.bhsah.com/wp-content/uploads/2010/01/happy-cat1-150x150.jpg">'

Worked around a bug in the SelectRow method so now when you select a marker that share latitude with other markers it will work.
Moved over to a newer version of markerclustererplus.

Re: Google Maps - Cluster

Thu, 11 Apr 2013 05:11:11 GMT

Thank you very much, Alexander!

I'll try new version of your expression today.

Popup windows in extension must be very useful!

About my problem with Stack errors:

My source data with coordinates I was loaded from Excel format, separator in coordinates was dot (XX.XXXXXXX).

After operation with coordinates in QV script (synthetic object allocation) OR after load data to QV separator has been changed to comma (XX,XXXXXXX).

Your extension not work properly with coordinates in such format (google static map works).

I stored the table in Excel format, replaced comma to dot and BINGO!

Thank you!

Re: Google Maps - Cluster

Alexander_Thor — Thu, 11 Apr 2013 16:20:03 GMT

Perfect! Yes coordinate sets has to be in ISO 6709 format, I probably should document that somewhere

Re: Google Maps - Cluster

Fri, 31 May 2013 20:33:24 GMT

Is there a way to refresh a Table Box when you zoom in on the Google Maps? So if you have 100 items in the Table Box and when I click on a cluster of 9, the Table Box is filtered down to only those 9?

Re: Google Maps - Cluster

Anonymous — Mon, 10 Jun 2013 18:37:06 GMT

there are some way to change the marker picture? for example a green marker for the better places and the red one for the worst?

Re: Google Maps - Cluster

Alexander_Thor — Mon, 17 Jun 2013 19:22:01 GMT

Not in any easy way I could think off.

I could trigger selections back to QV whenever you zoom into a cluster however that would cause the chart to re-render it-self and having to plot all the markers again which I guess is going to be a pain.