google map in qlikview

[Anonymous]

hello everyone

i am trying to implement google map in qlikview but its not showing properly.

Script:

googlemap:

LOAD [Country Code] as cc,

     latitude ,

     longitued,

     [Country Name] as cn,

    num( Rand()*1000000,'###0.00') as sales

FROM

(ooxml, embedded labels, table is Sheet1);

gmap_key = 'xx';

max_zoom_level = 17;

map_size_x=        '600';

map_size_y=     '400';

map_scale=        '2';

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

SET HidePrefix='_' ;

// Field required for calcualting best zoom level

_zoom_level:

Load RecNo( ) as _zoom_level autogenerate(max_zoom_level);

maptype:

LOAD * INLINE [

    maptype

    roadmap

    mobile

    satellite

    terrain

    hybrid

];

i am not getting exactly where i am stuck, please help me..

Thank you..

[MK9885]

I believed they have stopped this service in Google.

Either you have to buy their API or use Google Cluster or Bubble Chart to get same results.

Even though the Cluster or Bubble chart is free to use only in Development but in Production you may have to get their API.

Google Maps - Marker

Google Maps - Cluster