Google Map doesn't show right in Qlikview

[#1]

Hey Guys,

I have been working on how to show a few german cities with google maps within qlikview.

I should have the correct data with longitude and latitude as well as the correct skript taken from the tutorial.

Unfortunatly it shows me the germany cities displayed into the the "Atlantic Ocean" next to Africa.

How is this possible?

Thanks for the help in Advance

[#2]

Hi,

I think you must give us some more detail, or better a small application with the data you supplied.

regards,

Walter.

[#3]

Hey thanks for the reply.

I'm pretty new at this so I thought I attach the file to this writing.

Hope you could help.

Thx

[#4]

Hi, you haven't got your var_lat_offset specified and in the variable var_mid_long you have capitalised the Latititde, so just replace it with all lower case (QlikView is case sensitive). Worked on mine.

Cheers

Steve

[#5]

i just corrected it but its still the same...

what should I write in var_lat_offset???

[#6]

Needs to be 0, but you'll need to specify it in the Script, think I may have told you wrong. Its var_long_offset you are missing. Therefore enter the following in teh script (and change the upper case Longitude in there as well

var_long_offset= '0';

Cheers

[#7]

this is what I have and which is not working:

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)+(1-var_long_offset)*((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= '800';
map_size_y= '800';

what do you think?

thx

[#8 · Accepted solution]

Try this:

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)+(1-var_long_offset)*((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= '400';
map_size_y= '400';

[#9]

PERFECT IT WORKED!!!! Thank you so much you're a master 🙂

Is it possible to ask you more question or would it be too rude?

I would understand if...

Thanks