topic Google Map implementation in QlikView

Google Map implementation

stephenedberkg — Mon, 24 Aug 2015 06:29:39 GMT

i am trying to implement the Google map but i cant get the latitude and longitude

my script is below

// Google Maps Key

// geta key here http://code.google.com/apis/maps/signup.html

// gmap_key = 'xx';

max_zoom_level = 17; //maximum value 17

// Variables required for calculating map

// No need to change these

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';

SETHidePrefix='_' ;

// Field required for calcualtingbest zoom level

_zoom_level:

Load RecNo() as _zoom_level autogenerate(max_zoom_level);

maptype:

LOAD * INLINE [

maptype

roadmap

mobile

satellite

terrain

hybrid];

set hideprefix= 'maptype';

Re: Google Map implementation

jsingh71 — Mon, 24 Aug 2015 06:39:38 GMT

Hi,

You need to load Latitude and longitude values separately. Are you loading these values?

Re: Google Map implementation

vikasmahajan — Mon, 24 Aug 2015 06:44:09 GMT

Google Map for India

Go through this

Vikas

Re: Google Map implementation

stephenedberkg — Mon, 24 Aug 2015 06:54:34 GMT

i am not loading any values. i think this script is take the latitude and longitude values automatically for area Location wise..

Is it take automatically or not?

Re: Google Map implementation

vikasmahajan — Mon, 24 Aug 2015 06:57:49 GMT

why you want automatically ????

Re: Google Map implementation

stephenedberkg — Mon, 24 Aug 2015 07:07:14 GMT

latitude and longitude values

Re: Google Map implementation

mohammadkhatimi — Mon, 24 Aug 2015 07:12:34 GMT

Hie...

PFA is the example on Google Map implementation

Hope this will helps you...!!!

Regards,

Mohammad

Re: Google Map implementation

stephenedberkg — Mon, 24 Aug 2015 07:29:40 GMT

i am using trial version so cant open that QVW files.

i tried to implement this attached document wise but the map is not showing.

i am not set the google map api key.

Is it problem?