Wednesday, 19 August 2009

Google Maps QVW broken

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.

5 comments:

  1. Hi,
    noted 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

    ReplyDelete
  2. solved it - had a tying-error in my script.

    ReplyDelete
  3. Hi, Peter which url did you use to register with google ???
    didn't work for me? please help??
    i followed all the steps.
    thanks

    ReplyDelete
  4. 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
    Thanks.

    ReplyDelete
  5. This comment has been removed by a blog administrator.

    ReplyDelete