Qlik Community

QlikView Extensions

Discussion Board for collaboration on QlikView Extensions.

akl
Honored Contributor

Google Maps - Marker

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.

marker.PNG

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

Live long and prosper.

98 Replies
Employee
Employee

Re: Google Maps - Marker

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

akl
Honored Contributor

Re: Google Maps - Marker

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?

Employee
Employee

Re: Google Maps - Marker

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 ..

sokkorn_cheav
Honored Contributor

Re: Google Maps - Marker

Hi Alexander,

I try to set differenct MapMarker, but no luck.

Untitled.png

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

akl
Honored Contributor

Re: Google Maps - Marker

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.

sokkorn_cheav
Honored Contributor

Re: Google Maps - Marker

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

akl
Honored Contributor

Re: Google Maps - Marker

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.

sokkorn_cheav
Honored Contributor

Re: Google Maps - Marker

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

bruno_martins_l
Contributor

Re: Google Maps - Marker

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

Community Browser