The Google Maps example that comes with QlikView 9 has stopped working.
This is because Google have made a couple of changes. Luckily, it is resolveable.
Step 1:
Go to http://code.google.com/apis/maps/signup.html and sign up for a Google Maps API key.
This key, once you receive it, should be put into the document variable, gmap_key (the default value of "xx" will no longer work).
Step 2:
The .jpg that we need to put at the end of the URL so that QlikView knows the result is an image will break the URL because it is currently tagged onto the end of the API key. We need to add an additional '&' before the '.jpg' so that Google Maps can interpret the values correctly. It will ignore the "&.jpg" at the end.
- this appears to work OK (in the Colors tab of the Chart properies - Dynamic Image):
='http://maps.google.com/staticmap?center='
&
num(var_mid_lat, '##############', '.', ',' )
&
','
&
num(var_mid_long, '##############', '.', ',' )
&
'&zoom=$(var_zoom)'
&
'&size='&map_size_x&'x'&map_size_y
&
'&key='&gmap_key
&
'&maptype='&var_maptype
& '&.jpg'
Working fine for me now.
Hi,
ReplyDeletenoted the fix and many thanks. Problem for me is currently, that we have used the maps only in internal applications, thus when trying to register with Google, I have no website to enter
Peter
solved it - had a tying-error in my script.
ReplyDeleteHi, Peter which url did you use to register with google ???
ReplyDeletedidn't work for me? please help??
i followed all the steps.
thanks
i would also like to know the URL you used as i am also haing the same problem of using it in internal applications only
ReplyDeleteThanks.