google map in qlikview

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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..

Re: google map in qlikview

MK9885 — Fri, 03 Nov 2017 12:44:12 GMT

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

topic Re: google map in qlikview in QlikView

google map in qlikview

Re: google map in qlikview