topic Re: Google Map offset in QlikView

Google Map offset

Wed, 08 Jul 2015 09:09:48 GMT

Hi All,

I have an offset on all the points drawed on the Google Map, but when i zoom in, the points are better placed but not in their place, anyone know why ?

Before : (wrong)

Then, after zoom : (little bit better)

I followed this tutorial :

Step-by-Step Google Map API v3 integration

Thank you,

Loup

Re: Google Map offset

Wed, 08 Jul 2015 12:39:18 GMT

No one has had the same issue ?

Re: Google Map offset

sunny_talwar — Wed, 08 Jul 2015 12:45:17 GMT

Do you have a legend or borders on your chart? Try clearing out everything from the chart area and see if that helps. Can you post a screenshot of the whole chart, including the borders?

Best,

Sunny

Re: Google Map offset

Wed, 08 Jul 2015 12:53:55 GMT

I don't have any Legend on the chart...

Whole chart :

The script :

max_zoom_level = 17; //maximum value 17

var_pi180= '=pi()/180';

var_lat_offset1= '0';

var_mc21= '=256*pow(2,$(var_zoom1))';

var_mc11= '=256*pow(2,($(var_zoom1)-1))';

var_mid_lat1= '=min([Latitude Assure])+(1+var_lat_offset)*((max([Latitude Assure])-min([Latitude Assure]))/2)';

var_mid_long1= '=min([Longitude Assure])+(max([Longitude Assure])-min([Longitude Assure]))/2';

var_zoom1= '=max(aggr(if(max( round(256*pow(2,(_zoom_level1 -1)))+( [Longitude Assure] *((256*pow(2,_zoom_level1 ))/360)) )-min( round(256*pow(2,(_zoom_level1 -1)))+( [Longitude Assure] *((256*pow(2,_zoom_level1 ))/360)) ) <map_size_x1 AND max((256*pow(2,(_zoom_level1-1)))+((0.5*log((1+(sin(([Latitude Assure])*pi()/180)))/(1-(sin(([Latitude Assure])*pi()/180)))))*((-256*pow(2,_zoom_level1))/(2*pi()))))-min((256*pow(2,(_zoom_level1-1)))+((0.5*log((1+(sin(([Latitude Assure])*pi()/180)))/(1-(sin(([Latitude Assure])*pi()/180)))))*((-256*pow(2,_zoom_level1))/(2*pi()))))<map_size_y1,_zoom_level1,1),_zoom_level1))';

//var_zoom= '5';

var_maptype1= '=if(isnull(only(maptype)),fieldvalue( '&chr(39)&'maptype'&chr(39)&', 1 ),maptype)';

map_size_x1= '900';

map_size_y1= '850';

SET HidePrefix='_' ;

// Field required for calcualting best zoom level

_zoom_level1:

Load RecNo( ) as _zoom_level1 autogenerate(max_zoom_level);

set hideprefix = 'maptype';

Thank you

Re: Google Map offset

sunny_talwar — Wed, 08 Jul 2015 12:57:26 GMT

map_size_x1= '900';

map_size_y1= '850';

Try changing these to and see if that helps:

map_size_x1=

'640';

map_size_y1= '400';

Re: Google Map offset

Wed, 08 Jul 2015 13:01:20 GMT

It is good !

So I have to change the size in order to keep this ratio ?

Thank you !

EDIT: Seems that I have to keep theses little dimensions...

Re: Google Map offset

sunny_talwar — Wed, 08 Jul 2015 13:07:46 GMT

No problem

Just in the script, I think. Front end object can stay and looks the same.

Best,

Sunny

Re: Google Map offset

sunny_talwar — Wed, 08 Jul 2015 13:08:38 GMT

EDIT: Seems that I have to keep theses little dimensions...

Not sure what dimensions you are talking about, can you please elaborate?

Re: Google Map offset

Wed, 08 Jul 2015 13:12:39 GMT

Sorry, I was speaking about the size and not dimension (=in french).

If I keep the same front end object, it look horrible (in fact the map is extented), but when I change both size (script and front end), the offset appears, so I can't have a bigger map

Re: Google Map offset

sunny_talwar — Wed, 08 Jul 2015 13:13:49 GMT

Would you be able to share the application? I can take a look at it, if you want.

Best,

Sunny

Re: Google Map offset

Wed, 08 Jul 2015 13:17:52 GMT

Would like but I work with the demo version for now so I can't share it, thank you anyway.

I will try some things and post it there if I found the solution.

Loup

Re: Google Map offset

sunny_talwar — Wed, 08 Jul 2015 13:20:00 GMT

I have this map and it looks fine when I have it stretched out:

Re: Google Map offset

Wed, 08 Jul 2015 13:27:31 GMT

Yes, when keeping the ratio it is fine with me too, don't know why it was distorted...

Thank you a lot for your help sunindia‌

Re: Google Map offset

sunny_talwar — Wed, 08 Jul 2015 13:28:21 GMT

No Problem

I am glad it worked out for your in the end.

Best,

Sunny

Re: Google Map offset

Fri, 20 Jan 2017 11:02:35 GMT

Hi all!

Sorry to refloat this topic, but I have the same problem, the balls in the map has an offset regarding the place where balls must be; for example it you see Santiago and the ball with must be over it, the ball has an offset. The same for they all (in the image you can see Valparaíso and its ball, too):

The values of map size variables:

- map_size_x= '640';

- map_size_y = '400';

Thank you in advanced!!!!