Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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='_' ;
Tags (2)
1 Solution

Accepted Solutions
Not applicable

Google maps: Public Transport

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

1 Reply
Not applicable

Google maps: Public Transport

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