Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
since yesterday none of the google maps examples is working any longer in my QlikView Developer! (e.g. see The Google Maps Example with London flats!)
I registred for a new google maps key but there was no effect at all.
What happened? Did Google stop using the static google maps API for QlikView Developer??
I hope anybody will know the answer.
Thanks.
Fabian
Hi Fabian,
Looks like Google have decided that they don't want the .jpg at the end of the API Key. QlikView relies on this so that it recognises that the result is an image.
A little swapping of parameters solves it:
='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'
Regards,
Stephen
Hi Fabian,
Looks like Google have decided that they don't want the .jpg at the end of the API Key. QlikView relies on this so that it recognises that the result is an image.
A little swapping of parameters solves it:
='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'
Regards,
Stephen
Hello Stephen,
thank you for your answer. Indeed it works.
But with your code the maptype parameter won't be working any longer.
What happened?
Fabian
Hi,
Simple fix.
Just change:
& '.jpg'
to
& '&.jpg'
Stephen
OK. Thank you very much.
Fabian
Thanks a lot for this tip. Really appreciate it. Thought for a moment Google decided to ban Qlikview clients across their network. Without the change, even trying to embed an image from blogger as a dynamic image background would not work.
Pardon the grammar.
why it does not work to me? Here is my code. I added "&" in front of ".jpg"
='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'
Anyone could give me the complete code? Thanks
Hi,
Do you have a valid Google Maps API Key?
If you copy this code into a text box, does it create a valid looking URL? If you copy this URL into a web browser, does it work?
Stephen
Thanks Stephen,
I did some research and found I need the key.
Now everything works. Thanks again.
I cannot get this to work any longer...
I thought I registered for a valid key and it still doesnt work.. 1 week ago it did
Any ideas?
I am receiving"Your client does not have permission to get URL " when i use the text object and paste it into a URL