topic Re: Google Maps - Marker in QlikView

Google Maps - Marker

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

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.

Re: Google Maps - Marker

Julie_Main — Mon, 25 Mar 2013 09:24:32 GMT

Alexander, this is great, but did you ever work out how to change the markers? I tried and kept breaking the code .. cheers, Julie

Re: Google Maps - Marker

Alexander_Thor — Mon, 25 Mar 2013 09:34:44 GMT

Sure, any special image you want? You can email me it offline and I'll set it up.

Would an expression help out with icons? So you could build a dynamic icon based on your data?

Re: Google Maps - Marker

Julie_Main — Mon, 25 Mar 2013 09:44:21 GMT

Yes to both! I'll email you directly - it would be good to be able to have one icon for if there is a value and another if there is none ..

Re: Google Maps - Marker

Sokkorn — Wed, 27 Mar 2013 07:51:30 GMT

Hi Alexander,

I try to set differenct MapMarker, but no luck.

Can you help to guide me how can I set map marker with scenario below:

If ([Speed Limit]<70)
    {
        MapMarker = 'http://maps.google.com/mapfiles/ms/icons/blue-dot.png';
    }
Else If ([Speed Limit]<100)
    {
        MapMarker = 'http://maps.google.com/mapfiles/ms/icons/green-dot.png';
    }
Else
    {
        MapMarker = 'http://maps.google.com/mapfiles/ms/icons/red-dot.png';
    }

Thanks in advanced!!!

With warm regards,

Sokkorn

Re: Google Maps - Marker

Alexander_Thor — Wed, 27 Mar 2013 09:43:27 GMT

Hi,

You are trying to run javascript in a QV expression dialog.

The custom marker URL only accepts native qv functions so do a nested QV if statement.

Re: Google Maps - Marker

Sokkorn — Wed, 27 Mar 2013 09:47:51 GMT

Dear Alexander,

Thanks for your response.

I'm very new with extension and google map. Can you amend on your attached file to get this job done?

Thanks in advance!

Regards,

Sokkorn

Re: Google Maps - Marker

Alexander_Thor — Wed, 27 Mar 2013 10:22:56 GMT

Hey,

I'm sorry, I completly missunderstood you. The attached picture dident show up in my phone for some reason

Anyways your expression looks just fine and I tried it with success. See the attached file.

What could cause the problems is if you paste the expression into the extension property. QlikView won't respect your line breaks - so you would need to open up the expression dialog and paste the expression there.

And thanks for trying the extension! I'm happy you got it to work since I got some reports that it diden't load for some people and I tried debugging it without any success.

Re: Google Maps - Marker

Sokkorn — Wed, 27 Mar 2013 10:39:44 GMT

Dear Alexander,

Sorry for not clear purpose from me . And thanks for your attached file.

Go to this url http://www.geocodezip.com/v3_markers_normal_colored_infowindows_style.html then you will see five different colore marker in map.

So what I'm trying to achieve is set multiple marker in map base on [Speed Limit]. It is possible to do this?

Awaiting your reply.

Regards,

Sokkorn

Re: Google Maps - Marker

bruno_martins_l — Wed, 27 Mar 2013 11:08:43 GMT

Hello,

I have a question, If I want modifiy the image marker and use the images in Qlikview or in my serveur, I have tried with this expression but it's not works :

If(sum(Montant)>10000,

'C:\Users\bruno.martinsledo\Desktop\Application Banalisées\Ventes\Images\Essai.jpg'

If(sum(Montant)>5000,

'qmem://<bundled>/BuiltIn/exclamation_g.png'

'http://maps.google.com/mapfiles/ms/icons/red-dot.png'))

Can you help me please?

Kind Regards,

Bruno

Re: Google Maps - Marker

Alexander_Thor — Wed, 27 Mar 2013 11:53:36 GMT

Hi Bruno,

No you can't use bundled images. You can load local files that resides on your hard drive but that should be avoided.

However you can host your images either through QlikView webserver or if serve up Accesspoint through IIS then that works also.

Copy your images to C:\Program Files\QlikView\Web\ on the server (or the corresponding path where you installed qlikview server)

This is the folder that contains your Accesspoint files.

Now you should be able to browse to http://<your servername>/qlikview/<your image>.png

Proceed to use that url for your marker expression.

Re: Google Maps - Marker

Alexander_Thor — Wed, 27 Mar 2013 11:58:41 GMT

Hey Sokkorn,

No no I just need to read my e-mails better next time

You are on the right track in your first post and that expression should work out of the box.

If you look at the example I attached you will see three different colored markers.

So just expand on your QV expression to included more marker colors.

You could test it by creating a straight table with latitude and longitude as dimension and then plug in your expression and set the display representation to image. If you straight table looks fine then so will the Google Maps extension.

Re: Google Maps - Marker

Julie_Main — Wed, 27 Mar 2013 12:37:59 GMT

Right, i think I'm being a bit of an ejit .. I've put my image file into the following location:

C:\Program Files\QlikView\Web

and then in the definition.xml I have put in the following:

</ExtensionObject>

And yet it still doesn't show my cutom marker .. It's just a standard demo laptop, so uses localhost as the server name .. anything else I should have done?

I also tried entering this against the custom marker URL:

http://localhost/qlikview/icon1.png

Re: Google Maps - Marker

bruno_martins_l — Wed, 27 Mar 2013 13:25:32 GMT

Thanks a lot, but I have tried to put the extension in my server and with the exrepssion :

if(sum({<TME_LIBC={'CONSUMPTION'}>}MES_VAL1)>0, 'http://maps.google.com/mapfiles/ms/icons/blue-dot.png','http://maps.google.com/mapfiles/ms/icons/red-dot.png')

But the map stay empty.

Re: Google Maps - Marker

Julie_Main — Wed, 27 Mar 2013 14:09:38 GMT

Very pleased with my example and a huge thank you to Alexander!!

Re: Google Maps - Marker

Sokkorn — Thu, 28 Mar 2013 01:11:28 GMT

Dear Alexander,

Of cause, your second attached file work well in your PC with three different marker. But for me it doesn't work. OMG, I spend nearly 4 hours to read your message in bold text below.

Alexander Karlsson wrote:
Hey Sokkorn,
No no I just need to read my e-mails better next time
You are on the right track in your first post and that expression should work out of the box.
If you look at the example I attached you will see three different colored markers.
So just expand on your QV expression to included more marker colors.
You could test it by creating a straight table with latitude and longitude as dimension and then plug in your expression and set the display representation to image. If you straight table looks fine then so will the Google Maps extension.

So why it not work in my PC? Because I use the original extension and at that time you have edit your extension and share me only .qvw. Finally I try to amend your extension (script.js and Definition.xml) and then it get my job done .

A big thanks to you...

Cheer!!!

Sokkorn

Re: Google Maps - Marker

Alexander_Thor — Thu, 28 Mar 2013 07:25:12 GMT

Hi Sokkorn,

Don't really know what you are talking about. Let's just be crystal clear, you do not need to edit any code.

Right click your map, hit properties, in the custom marker url box hit the fx sign and write your normal qlikview expression there.

If you are having problem with the match function there is good documentation in the qlikview help file that should get you started or you could just paste the following expression in there.

If(Match([Speed Limit],40,50,60),

'http://maps.google.com/mapfiles/ms/icons/blue-dot.png',

If(Match([Speed Limit],70,80,90),

'http://maps.google.com/mapfiles/ms/icons/green-dot.png',

'http://maps.google.com/mapfiles/ms/icons/red-dot.png'))

Re: Google Maps - Marker

Sokkorn — Thu, 28 Mar 2013 08:05:25 GMT

Dear Alexander,

It sound you just uploaded a new extension. Below attached file was download since 25-Mar-2013 7:43 AM. And look into this, we found some different line code.

Anyhow, I would like to say many thanks for your input on my queries .

Cheer!!!

Sokkorn

Re: Google Maps - Marker

Julie_Main — Thu, 28 Mar 2013 11:05:01 GMT

Is there a limit on the markers? I remember that there was with the original one .. I'm getting a Stack Overflow error (not sure if this is to do with number of markers?), in the js, although I have increased this in the xml file to 200,000. ( I think my total markers are 24,000 or so). I'm already trying to tie this into another application ;0) I'll also give the clustering extension object a go as well, as this might work better although it doesn't have the customisable icons ;0) - another quick job Alexander?!!

Re: Google Maps - Marker

Alexander_Thor — Thu, 28 Mar 2013 11:54:27 GMT

See my answer in the cluster thread. All three extensions share the same code base so it might just be a data problem

Kind Regards

Alexander Karlsson

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

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

Re: Google Maps - Marker

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