Google Maps - Cluster

[Alexander_Thor]

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.

[#2]

there some kind of limit load of points?
to use the google api premier, I have to modify the JS?

Greetings and thanks

[Alexander_Thor]

Yes well that makes sense. This extension will show you a cluster when you have several markers that's close by. Right now your markers are so far apart there is no need to cluster them together.

If you still want to cluster them you could increase the Cluster Size property in the extension properties.

Also right now the colors of the clusters are hard coded and can't be changed.

[#4]

Thanks for your reply Alex. Yes, you are right, the markers are so far apart that there are very few clusters formation in my chart. Actually I've realized that I am not looking for clusters in the map, instead my user wants to see the actual numbers (total count) for different locations on the map. So like instead of going to the marker and hover the mouse to check the total count, they would want that to be displayed in the map itself. Is this possible by any chance? or is there any other extension/tool etc, that you could recommend for this use case.

Thanks very much.

-Yaman

[Alexander_Thor]

Not sure if there is a extension object that would do that out of the box.

However you should be able to achieve that with the static maps embedded in a scatter plot, make the bubble color transparent and enable plot values inside of segment.

[#6]

Oh Cool... I'd try that. Thanks Alex.

[hdonald]

Hi,

Has anyone tried adding Googles Map API Drawing Tools to a map extension like this ?

I've had a quick go, 'Script' text attached, for demo purposes but have run into a problem with multiple selections in Qlikview.

If I use the polygon tool to select many lat/long marker values in Qlikview the 'Back' button will roll back one selection at a time - how do I get it to jump back to the selection state just before the polygon was used ?.

Apologies if this question has come up before, but I'd appreciate it if someone could point me in the right direction,

Regards,

HD    

[Alexander_Thor]

Hi Hamish,

First of all, thank you!

It's great seeing someone making the effort and improving this extension which was the intention to begin with

I'm currently reworking a lot of the extensions, do you mind if I incorporate it to the main code base?

On to your problem:

I've looked into it and it might be a bug. Currently working my way backwards through the logic of QvAjax.js to track it down. Worst case scenario we could hook into the core methods instead of working with the exposed API.

[hdonald]

Hi Alexander,

I'm glad I could help, please go ahead and use anything that's useful.  This looks like a really handy extension and if it had the polygon/shape selection as well it would be even better. 

My efforts hit problems with the 'SelectTextsInColumn' lines, as although it successfully selected all items in the marker arrays 'matchLat' and 'matchLng' any use of the Back button afterwards steps back one select at a time in each of the Latitude and Longitude dimensions, so the user has to hit Clear and start the zooming in/selection process again.

That's a bit inconvenient so I probably can't get past the demo stage without some kind of solution for this.  I look forward to seeing what your revised version does,

Regards,

Hamish

[#10]

Hi,

I have an application with this google map, it works on my desktop. Even when I open QlikView Desktop on Server, the map is working fine. But when I open the document in Access Point the map object isn't showing. We can access to maps.google.com on IE on server

I've added the extension on server.

Path:

C:\ProgramData\QlikTech\QlikViewServer\Extensions\Objects\GoogleMaps - Cluster

I've also checked the Alternate Path Extension in QV Management Console

Server Info:

QV 11.00.11282.0 SR1 (x64)

Internet Explorer 8

Are we missing any configuration?? Please help!! We really need the extension working through access point.

Thanks,

Bere

[Alexander_Thor]

Have you enabled Extensions through QMC?

System -> QlikView Servers -> Your QVS(s) -> Security -> Make sure "Allow Extensions" are checked.