Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Google Maps Extension with Markers.
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 into QlikView.
Load a set a coordinates into QlikView and visualize them together with this extension. This extension will plot every single data point as a marker on the map so if you have a large amount of markers please be aware that it might have some performance impact. If you are experiencing performance issues look into the cluster extension instead: http://community.qlik.com/message/325640
You can either use the extension 'as is' or use it as a base to further customize it to fit your needs.
Custom Markers
Added support for custom markers images. In the properties dialog you now have the option to specify a custom image.
You can either have a static image or let the expression evaluate one for you, for example:
=If(MyExpression > 1, 'http://image_for_true', 'http://image_for_false'). If you do not specify an url or enter an invalid one the extension will fallback to the standard marker.
Supported image extensions are bmp, jpg, jpeg, tiff, png and gif.
You can host the images through the qlikview webserver or through IIS.
If you build something awesome please share it with the community!
Live long and prosper.
Every time I add a custom marker It shows them squeezed to to the point I cant tell what it is. I used a simple string to modify the marker expression: http://maps.google.com/mapfiles/ms/icons/blue-dot.png'
What would cause this to happen? See attched. I used the one already posted with green/blue markers to test.
Hello,
Is there any way to put 2 different markers on the map?
I have two tables with store locations and customer locations
I want to be able to show a store location as one marker and all the corresponding customers that has gone to that store as different markers, but corresponding coordinates are stored in different fields.
Hmm, well try to solve it in the data model since that would be the most performance efficiant both from calculation time and RAM consumption since you will get higher compression.
Hi ALexander
Thanks for making the extension available. Does this works with Personal Edition?
I have added Google Object, I have excel with few countries and Log and Lat information.
When I click property of Google object, I am unable to key in any values or Assign any Field
Am I making any mistake?
Thanks
Hey, yes it works with Personal Edition. All extensions do as long as you are running QV in web view.
If you are able to open the properties dialog but unable to enter any values most likely you are either running QV11 SR1 (which had a bug related to property panels) or you have IE10 installed (either downgrade or wait for 11.2 SR2 which is planned to ship soon).
I have also seen some cases where you only had 2-3 fields in your data model and QV for some reason wont let you enter anything in the dimension drop down boxes of extensions.
Dear Alexander, many thanks for your extension. It worked great for me.
But still wondering how to use this withint the Reports, because when I drop the objetct to the Reports sheet it says that the objetc is not recognized.
Can you please help me to knkow how to use this extension within the qlikvies reports??
Many thanks in advance,
BQ.
Hi Alex,
Would like to ask why the chart doesn't work anymore after I changed the expression formula (yours is sum(Lat) and I changed to sum(1) for testing) ?
Besides, I found that in your QVW, that map object become an "unknown object" in the properties. After I changed the expression, the map object become a "BAR" chart and it doesn't work. Then, if I would like to create a new object like yours, what're the steps to create an "unknown object" ?
Thanks a lot for your help.
HL
Hi Alexander,
I have tried to use your extension but I get an error that your browser does not support xmldocument object. Can you please tell me how can I use this extension in my Qlikview document. I need to use markers in google maps in my qlikview dashboard
Arif
Hi,
You would need to turn on webview in the desktop client in order to view extensions.
I would suggest you read up a little bit on extensions before you venture any further.
This is a good introduction: QlikView Extension Tutorial #1: The Concept of QlikView Extensions
My guess is that you are running the latest version of IE on your computer which get's installed with windows update.
The latest version of IE breaks the web view functionality in the desktop client, so you would have to downgrade to an earlier version of IE.