topic Why this typical Google Maps example doesn't work? in QlikView

Why this typical Google Maps example doesn't work?

marcel_olmo — Mon, 23 Aug 2010 16:30:24 GMT

Hello Guys, I've just added the typical Google Maps Example and I cannot make it work. I think it's maybe because of the new version of QV 10.

Otherwise I cannot understand why the latitude and longitude showed are 0.

In the following example I just only add some example code of geocoding data and the typical code for a Google Maps QV Aplication.

I just cannot make it work and I don't understand why, in the first case, the latitude and longitude are 0, and in the second one the result cannot be shown.

Any ideas? Would be kindly appreciated.

Here I leave the code. cheers! :

Data:
LOAD * INLINE [
Country,Population,GDP_PPP_M, latitude, longitude
Albania, 3600523, 19621, 41.153332, 20.168331
Algeria, 33858000, 269201, 28.033886, 1.659626
Argentina, 40301927, 523169, -38.416097, -63.616672
Armenia, 3230100, 17139, 40.069099, 45.038189
Australia, 21446187, 760800, -25.274398, 133.775136
Austria, 8340924, 317800, 47.516231, 14.550072
Azerbaijan, 8629900, 64082, 40.143105, 47.576927
Bahrain, 760168, 24245, 25.930414, 50.637772
];

// Google Maps in QlikView
// V0.9 - 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 = 'ABQIAAAAz3xOFbWaADVwBmLMzSJPmhRi_j0U6kJrkFvY4-OX2XYmEAa76BTcfAuv2czfjGrx_DULHCHDEGsRSw';
max_zoom_level = 5; //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= '640';
map_size_y= '400';

SET HidePrefix='_' ;
// 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
];

Why this typical Google Maps example doesn't work?

marcel_olmo — Mon, 23 Aug 2010 17:27:30 GMT

It's weird because I'm checking out with my work colleagues and everything seems to be fine. But it doesn't work.

Anybody knows why?

Many thanks per advance

Why this typical Google Maps example doesn't work?

Mon, 23 Aug 2010 20:03:09 GMT

Hi Marcel,

This issue is always the same problem.

Just change the setting

SET ThousandSep='.';
SET DecimalSep=',';

cheers

jjj

Why this typical Google Maps example doesn't work?

marcel_olmo — Tue, 24 Aug 2010 08:52:13 GMT

Merci beaucoup Jean Jacques for your quick answer.

I tried to figure out what do you mean with "changing the default settings" of the Thousand separator and the Decimal separator.

What do you exactly mean? I tried many combination formating these separators and it still doesn't work.

Many thanks by advance.

Why this typical Google Maps example doesn't work?

Tue, 24 Aug 2010 13:37:19 GMT

Marcel,

Use a dot as decimal separator :

SET DecimalSep='.'

and set Thousand separator to

SET ThousandSep=' ';

hope it works.

JJJ

Why this typical Google Maps example doesn't work?

marcel_olmo — Tue, 24 Aug 2010 13:45:46 GMT

Many thanks Jean Jacques.

Now it works fine. I cannot understand why it's so important this little stuff, but, thank you very much, you save me a big headacke.

See you around.

Cheers!