topic Re: Google map on grid chart doesn't correspond to coordinates in QlikView

Google map on grid chart doesn't correspond to coordinates

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I've found this example of pie charts on google map on Community and thought it will be useful for my analyses. I've changed the cities to Polish ones. However, I think there is some kind of zooming problem. When one city is selected only, then the dot is marked in the right place e.g. for Krakow. When multiple cities are visible - the dots are in incorrect places. So looks like because of zooming error the map picture doesn't correspond to latitude and longitude axes.

Has anyone built a map like that and can solve the problem here or attach your object?

Many thanks in advance.

Justyna

Re: Google map on grid chart doesn't correspond to coordinates

migueldelval — Tue, 28 Jun 2016 08:24:39 GMT

Hi j.kaliszczak,

Try this, //def_zoom_level = 6; in your script, If not attach excel file to see what is the problem.

Regards

Miguel del Valle

Re: Google map on grid chart doesn't correspond to coordinates

Tue, 28 Jun 2016 08:30:53 GMT

Hi Miguel,

I already tried with def_zoom_level but with no success.

Here is the excel file.

Justyna

Re: Google map on grid chart doesn't correspond to coordinates

migueldelval — Tue, 28 Jun 2016 09:41:59 GMT

!Hi,

Try this qvw and tell me please.

Regards

Miguel del Valle

Re: Google map on grid chart doesn't correspond to coordinates

Tue, 28 Jun 2016 10:15:22 GMT

Hi Miguel,

thanks for your effort. However, it's still incorrect.

When you deselect all Cities then the pie charts are in totally wrong places - you can see one is even in Baltic Sea (should be Gdansk), one in Belarus instead of Poland (should show Warsaw).

Also, I'd prefer the zoom not go into the street map of the city center when selecting one city, just zoom a bit to show still a piece of the country.

Thanks

Justyna

Re: Google map on grid chart doesn't correspond to coordinates

migueldelval — Tue, 28 Jun 2016 15:40:23 GMT

Hi j.kaliszczak,

I think that your first problem could be the axes. Try This values as picture show.

Max

=(256*pow(2,($(var_zoom)-1)))+( var_mid_long *((256*pow(2,$(var_zoom)))/360)) -round(map_size_x/2)

Min

=( (256*pow(2,($(var_zoom)-1)))+( var_mid_long *((256*pow(2,$(var_zoom)))/360)) + round(map_size_x/2))

Max:

=((256*pow(2,($(var_zoom)-1)))+((0.5*log((1+(sin(var_mid_lat*pi()/180)))/(1-(sin(var_mid_lat*pi()/180)))))*((-256*pow(2,$(var_zoom)))/(2*pi())))+round(map_size_y/2))

Min

=((256*pow(2,($(var_zoom)-1)))+((0.5*log((1+(sin(var_mid_lat*pi()/180)))/(1-(sin(var_mid_lat*pi()/180)))))*((-256*pow(2,$(var_zoom)))/(2*pi())))-round(map_size_y/2))

Regards

Miguel del Valle

Re: Google map on grid chart doesn't correspond to coordinates

Anil_Babu_Samineni — Tue, 28 Jun 2016 17:51:42 GMT

Mighuel,

In this chart, Those Scales are hidden

Update: How to create Zoom Symbol for that graph like Google Maps....

Re: Google map on grid chart doesn't correspond to coordinates

Wed, 29 Jun 2016 08:29:18 GMT

Hi Miguel,

axes properties are not active in case of the map on grid chart, so I can't change them.

Justyna