Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

google maps does not appear in QV

Hi all,

I always use a google map in qv. But recently, the image no longer appears. When I look at properties/colors then I see the following link:

='https://maps.google.com/staticmap?center='&Replace(var_mid_lat_c,',','.')&','&Replace(var_mid_long_c...'

1.JPG.jpg

does anyone know why the image is no longer visible? I think it has to do with the link.

Greetings,

Hans Steenhuis

3 Replies
Gysbert_Wassenaar

That looks like you're using the old V2 api which has been deprecated. You'll need to use the V3 api now.

See this discussion: http://community.qlik.com/message/335685#335685


talk is cheap, supply exceeds demand
Not applicable
Author

Thanks a lot for your comment. I change the code in:

='http://maps.google.com/staticmap?key='& gmap_key & '&center='&Replace(var_mid_lat_c,',','.')&','&Replace(var_mid_long_c,',','.')&'&zoom=$(var_zoom_c)'&'&maptype='&var_maptype&'&size='&def_map_size_w&'x'&def_map_size_h&'&.jpg'

In the Load screen is the folowing code:

def_map_size =   '624';

def_zoom_level = '6';

def_map_size_h = '624';

def_map_size_w = '624';

var_lat_offset = '0';

// var_mid_long_c = '=median(longitude)';

var_mid_long_c = '=min(longitude)+(max(longitude)-min(longitude))/2';

// var_mid_lat_c =  '=median(latitude)';

var_mid_lat_c =  '=min(latitude)+((max(latitude)-min(latitude))/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_n =  '=if(isnull(only(maptype)),fieldvalue( '&chr(39)&'maptype'&chr(39)&', 1 ),maptype)';

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

var_maptype_z =  '=fieldvalue( '&chr(39)&'maptype'&chr(39)&', 5 )'

var_zoom_c =     '=if(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)) ) <def_map_size 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()))))<def_map_size,zoom_level,null()),zoom_level))>def_zoom_level, 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)) ) <def_map_size 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()))))<def_map_size,zoom_level,null()),zoom_level)),def_zoom_level)-1';

var_zoom_1 =     '=var_zoom_c + 1';

var_XMin_c =     '=((256*pow(2,((var_zoom_c)-1)))+((var_mid_long_c)*((256*pow(2,(var_zoom_c)))/360))-(def_map_size*0.5))';

var_XMax_c =     '=((256*pow(2,((var_zoom_c)-1)))+((var_mid_long_c)*((256*pow(2,(var_zoom_c)))/360))+(def_map_size*0.5))';

var_YMin_c =     '=((256*pow(2,((var_zoom_c)-1)))+((0.5*log((1+(sin((var_mid_lat_c)*pi()/180)))/(1-(sin((var_mid_lat_c)*pi()/180)))))*((-256*pow(2,(var_zoom_c)))/(2*pi())))+(def_map_size*0.5))';

var_YMax_c =     '=((256*pow(2,((var_zoom_c)-1)))+((0.5*log((1+(sin((var_mid_lat_c)*pi()/180)))/(1-(sin((var_mid_lat_c)*pi()/180)))))*((-256*pow(2,(var_zoom_c)))/(2*pi())))-(def_map_size*0.5))';

// Google Maps in QlikView

// V0.85.2 - October 1st 2008  © Copyright QlikTech International AB 2008 / AES

// Google Maps Key

// get a 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-c = '=min(latitude)+(1+var_lat_offset)*((max(latitude)-min(latitude))/2)';

// var_mid_long-c = '=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';

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

];

Coordinaten:

LOAD @1 as PostcodePAT,

     Replace(@2, '.', ',') as latitude,

     Replace(@3, '.', ',') as longitude

FROM

[..\Data\Google maps\pccoord.csv]

(txt, codepage is 1252, no labels, header is 1 line, delimiter is ';', msq);

I have the folowing code from Google:

Key for browser apps (with referers)

API key:

AIzaSyCeibKbBQWHiW9kggXuo9WUL3xRf0-fkY8

Referers:

Any referer allowed

Activated on: Nov 4, 2013 1:03 AM

What will I have to change?

Greetings,

Hans

Gysbert_Wassenaar

Perhaps this blog post helps you get it right: http://luciancotea.wordpress.com/2013/07/04/google-maps-api-changed-from-v2-to-v3/


talk is cheap, supply exceeds demand