topic Binary load Google maps in QlikView

Binary load Google maps

Wed, 29 Feb 2012 16:25:04 GMT

Hi there all,

I recently worked with google maps in qlikview so far so good. Got the right map and everything worked fine. But now i try to do a binary load and then the maps don't appear anymore. I can see the spots etc but not the map underneath.

What''s going wrong. Because in the file where the script is reloading the maps are okay, but in the document where i do a binary load and copied the maps into a new sheet there's nothing to appear.

Can anyone help me with that?

Thanks a lot!!!

Binary load Google maps

Wed, 29 Feb 2012 16:34:29 GMT

Just to make sure I follow what you are doing, you've created a second QVW into which you are binary loading the data from your original file. You have then copied the map from your first QVW into the new one?

Binary load Google maps

Wed, 29 Feb 2012 19:09:40 GMT

Yes that is correct. The binary load is just for performance of the server

Binary load Google maps

Wed, 29 Feb 2012 20:17:14 GMT

Don't see why that shouldn't work. I'll give it a try and see what happens. What version of QV are you running.

Binary load Google maps

Wed, 29 Feb 2012 20:19:36 GMT

version 10. I exactly copy the objects and still the background of the map isn't showing. Nothing to do with another machine or internet or anything i can think of.

Thanks for helping!

Binary load Google maps

Tue, 06 Mar 2012 16:39:41 GMT

I finally got round to trying this in v10 and it failed for me too. Not sure why yet but will have a play and see if I can work it out.

Binary load Google maps

erichshiino — Tue, 06 Mar 2012 17:15:15 GMT

Hi,

I believe you have to copy the script tab with the google maps variables.I don't think that binary load will copy the variables, but just the tables.

Regards,

Erich

Binary load Google maps

Tue, 06 Mar 2012 22:08:07 GMT

Erich is right!

I copied the script variable relating to the google map into the new QVW and re-ran it and it started working perfectly! In the map app I used they look like this so should be similar in yours:

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

map_size_y= '400';

Binary load Google maps

Wed, 07 Mar 2012 13:18:52 GMT

Thanks for helping. It worked fine now! I really didn't know that a binairy load didn't take the variables too.