Google Map Issue

Mon, 24 Mar 2014 11:31:33 GMT

Hi All,

Here I am not getting the proper latitude and longitude for counting the Number of Customer.Bubbles are not coming and if coming at wrong places.

PFA of the Qlikview Application..

Thanks.

Re: Google Map Issue

sushil353 — Tue, 25 Mar 2014 05:00:28 GMT

Hi Piyush,

Goto Colors tab > Dynamic Images Past below code:

='http://maps.google.com/maps/api/staticmap?center='

num(var_mid_lat, '##############', '.', ',' )

','

num(var_mid_long, '##############', '.', ',' )

'&zoom=$(var_zoom)'

'&maptype='&'satellite'

'&size='&map_size_x&'x'&map_size_y

'&sensor=false'

Also in the map script paste below code:

max_zoom_level = 4;

var_pi180= '=pi()/180';

var_lat_offset= '0';

var_mc2= '=256*pow(2,$(var_zoom))';

var_mc1= '=256*pow(2,($(var_zoom)-1))';

var_mid_lat= '=min(Latitude)+(1+var_lat_offset)*((max(Latitude)-min(Latitude))/2)';

var_mid_long= '=min(Longitude)+(max(Longitude)-min(Longitude))/2';

var_zoom= '=max(aggr(if(max( round(256*pow(2,(_zoom_level -1)))+( Longitude *((256*pow(2,_zoom_level ))/360)) )-min( round(256*pow(2,(_zoom_level -1)))+( Longitude *((256*pow(2,_zoom_level ))/360)) ) <map_size_x AND max((256*pow(2,(_zoom_level-1)))+((0.5*log((1+(sin((Latitude)*pi()/180)))/(1-(sin((Latitude)*pi()/180)))))*((-256*pow(2,_zoom_level))/(2*pi()))))-min((256*pow(2,(_zoom_level-1)))+((0.5*log((1+(sin((Latitude)*pi()/180)))/(1-(sin((Latitude)*pi()/180)))))*((-256*pow(2,_zoom_level))/(2*pi()))))<map_size_y,_zoom_level,1),_zoom_level))';

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

map_size_x= '640';

map_size_y= '400';

SET HidePrefix='_' ;

// Field required for calcualting best zoom level

_zoom_level:

Load RecNo( ) as _zoom_level autogenerate(max_zoom_level);

Hope this will work. if not then let me know.

Sushil

Re: Google Map Issue

vikasmahajan — Tue, 25 Mar 2014 05:01:59 GMT

refer this Latitude and Longitude Finder Lat Long Lookup site for finding latitude and longitude information will get correct and this discussion

Latitude and longitude finding and creation of maps

Hope this help you

Vikas

topic Google Map Issue in QlikView

Google Map Issue

Re: Google Map Issue

Re: Google Map Issue