Qlik Community

Ask a Question

QlikView Integrations

Discussion Board for collaboration on QlikView Integration.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Alexander_Thor
Employee
Employee

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.

99 Replies
Julie_Main
Employee
Employee

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

Alexander_Thor
Employee
Employee
Author

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?

Julie_Main
Employee
Employee

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

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

Alexander_Thor
Employee
Employee
Author

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

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

Alexander_Thor
Employee
Employee
Author

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

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

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