Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Google maps: Public Transport

Hi. I have managed to successful map UK postcodes onto a google map in QlikView, thanks to the support on this forum. What Id like to do is add public transport data (specifically the london undergroud network) on top of this. Is this possible?My googlemap-script bit contains the following:
var_pi180
=          '=pi()/180';
var_lat_offset =     '0';
var_long_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='_' ;
1 Solution

Accepted Solutions
Not applicable
Author

Hi Alphie

Are you trying to add line data, or just the stations (as points)?

The points would be very simple, you could do this using the method of a scatter plot, which has been described before.

There is no way to display line data in the dynamic google maps, you would have to work around by overlaying a picture, or to similar effect, but much more complicated maybe use line chart!

What are you trying to do?

Erica

View solution in original post

1 Reply
Not applicable
Author

Hi Alphie

Are you trying to add line data, or just the stations (as points)?

The points would be very simple, you could do this using the method of a scatter plot, which has been described before.

There is no way to display line data in the dynamic google maps, you would have to work around by overlaying a picture, or to similar effect, but much more complicated maybe use line chart!

What are you trying to do?

Erica