topic Re: See Map in QlikView in QlikView

See Map in QlikView

ezec1807 — Wed, 25 Nov 2020 16:16:04 GMT

Good!
I'm creating a map in QlikView with a Scatter chart, and in the Colors / Image option I put this code:

= 'Http: //maps.googleapis.com/maps/api/staticmap? Center ='
& var_mid_lat
Eur-lex.europa.eu eur-lex.europa.eu
& Var_mid_long & '
& Zoom = $ (var_zoom) '&'
& Maptype = '& var_maptype &'
& Size = '& map_size_x &' x '& map_size_y &'
& Sensor = false '

The first query, is if this is legal or I have to load it another way.
The second query is if you have a limit on the map navigation in QlikView, because, yesterday after having worked during the day, on the map chart I threw an image with the attention sign And He did not show the map anymore. Today I opened it again and I had no problem seeing it.

Thank you very much for the answer!

Regards,
Ezequiel

Re: See Map in QlikView

MK9885 — Wed, 09 Nov 2016 18:42:10 GMT

There is no issue with the code you've got.

But Google Maps API's are not totally free anymore. Before it was but when you using the API in production then please make sure you can.

For personal/developing/testing it is free, not in production (this is what I'm aware of).

If there is anyone else who worked or working on Maps can guide you better?

Pricing and Plans | Google Maps APIs Pricing and Plans | Google Developers

Google puts a limit on free Google Maps API: over 25,000 daily and you pay | Technology | The Guardian

Why not use SVG Maps? It is totally free to use. It will be polygon layers but not a bubble style map.

Re: See Map in QlikView

ezec1807 — Wed, 09 Nov 2016 20:21:53 GMT

Thanks for the reply! But how do I apply this SVG map with the QlikView code I have? Thank you! Regards, Ezequiel

Re: See Map in QlikView

MK9885 — Thu, 10 Nov 2016 13:41:40 GMT

Your code would't work in SVG Maps but if you looking for Europe Map then you need to have Europe's country code which will be

Ex: Country Code

United Kingdom UK

Germany GE

You'll get those ISO codes online for free and then you need to select your country in options in your case Europe

So type in Europe.svg (these maps are pre stored and are static)

You'll also get a pop up option in SVG, color coding can be done as well.

If you have a sample data I'll make an example map for you?

Meanwhile I've attached the SVG extension which you can use and check for your self.

Your region ID will be ISO code for European countries

Map will be Europe

Load path will be europe.svg

And rest is common, color, pop up content, measure...

But this will be a polygon map once you fill in all details

Once you have everything in place the map will populate, below is for US Map which I have created and popup I used is State Name, you cal also use measures and also use a Table box as a pop up in measure.

Re: See Map in QlikView

ezec1807 — Thu, 10 Nov 2016 18:36:01 GMT

Thank you Aehman! I am in Argentina. The SVG extension, where can I get it? Thank you very much!!! Regards, Ezequiel

Re: See Map in QlikView

MK9885 — Thu, 10 Nov 2016 18:57:09 GMT

I've attached the extension in my above post below the US Map Image & np. Try it and you'll understand the options, pretty much similar to Google maps.

You can have a hover over Pop up table like below

Here I selected Europe Map with country as Ukraine.

To create a Table Box pop up use the below code in Pop up

= '<table border = "1" style="width: 350px;">' &
'<tbody>' &
'<tr>' &
'<td colspan="2" style="text-align:center;font-size:14px;">' &
'Country = ' & Country & ' ' &
'State = ' & Your Expression,'N/A') & ' ' &
'Expression Name = ' & Your Expression), '$#,##0.00') & ' ' &
' Expression Name :'&Your Expression)&' ' &
' Expression Name :'&Your Expression &' ' &
' Expression Name :'&Your Expression &
'</td>' &
'</tr>' &

'<tr>' &
'<td style="text-align:center; font-size:12px;">' &
'Total Investment: '& Your Expression
&
'<td style="text-align:center; font-size:12px;">' &
'Test: '& Your Expression

You can add either dimensions or expressions in place of

Your Expression in above code & can have more than 4 or 5 expressions or dimensions as pop in table box. Making sure it doesn't look messy for users.

Re: See Map in QlikView

ezec1807 — Thu, 10 Nov 2016 19:08:39 GMT

Thank you very much!!!

Re: See Map in QlikView

ezec1807 — Mon, 14 Nov 2016 16:19:13 GMT

Good!
With the same code above
"
= 'Http: //maps.googleapis.com/maps/api/staticmap? Center = '
& var_mid_lat
Eur-lex.europa.eu eur-lex.europa.eu
& Var_mid_long & '
& Zoom = $ (var_zoom) '&'
& Maptype = '& var_maptype &'
& Size = '& map_size_x &' x '& map_size_y &'
& Sensor = false '
"
I would like to apply the openstreetmap map since it is free but I do not know how to do it. Can someone help me?

Greetings, Ezequiel

Re: See Map in QlikView

ezec1807 — Mon, 14 Nov 2016 18:11:32 GMT

I was able to incorporate it into QV. But the navigation is very slow (zoom). The code entered was:

= 'Http: //staticmap.openstreetmap.de/staticmap.php? Center ='
& var_mid_lat
Eur-lex.europa.eu eur-lex.europa.eu
& Var_mid_long & '
& Zoom = $ (var_zoom) '&

Regards,
Ezequiel

Re: See Map in QlikView

MK9885 — Tue, 15 Nov 2016 16:33:41 GMT

You've tried above code in SVG map?

Or which extension are you talking about?

SVG Map will not support the above code. You do not need API's for SVG.

Zoom level will be activated only if a user click on a data point or state.

Please upload a screenshot of what extensions you're using? (Google Maps or SVG?) After knowing that only I can help you better.

Thanks.

Re: See Map in QlikView

ezec1807 — Tue, 15 Nov 2016 16:44:22 GMT

Hello! I'm trying to create a map other than through an extension. Because in my browser I work with the plug-in, and I have been told that extensions do not work with the plug-in. I'm testing with openstreetmaps that without free.

Thank you very much for your help!

Regards, Ezequiel

Re: See Map in QlikView

MK9885 — Tue, 15 Nov 2016 18:00:22 GMT

So you trying to build a map in Scatter Chart?

If yes, then the following link might be helpful... and I suggest try to work around the Extensions.

Step-by-Step Google Map API v3 integration

As I've asked before, what is your IE version? Is it IE8 or IE11? Install the latest version and make some changes in QMC, you'll be able to create maps. I'm using same extension as above, I have no problem with Plugins/Flash players. an updated version will provide you everything.

Many times Google will suspend the Static Maps

Re: See Map in QlikView

ezec1807 — Wed, 16 Nov 2016 13:28:59 GMT

Hello! I have IE8 and IE11. I made a scatter chart, with the static image of openstreetmap. I was able to do it successfully. At another time I tried with the googlemaps API and as it is limited I put it aside and I searched for an API that is free to use as openstreetmap. Thank you! Regards, Ezequiel

Re: See Map in QlikView

MK9885 — Wed, 16 Nov 2016 13:35:24 GMT

Almost all the Extensions will only work in IE11.

Make sure whenever you are/users in Access Point they have latest version of IE installed. Scatter Chart is good idea to build a map but I'm not sure if Google has suspended the services for static map.

You can try and also go through the link which I've given for Step by Step Google Map API V3 Integration.

Thanks.

Re: See Map in QlikView

ezec1807 — Wed, 16 Nov 2016 13:40:28 GMT

In IE8 and IE11 the extensions work, the problem is that as in this browser I use the plug-in that is why the extensions do not work. For this reason I decided to make the map from a scatter object and load a free image of use as openstreetmap.

Thank you!

Regards, Ezequiel