Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is anyone else having trouble with the Google Maps layer disappearing from existing Qlikview applications? As of today nothing on either desktop or server-hosted Qlikview has a Google map in the background.
We're running Qlikview 11.
I tested the Qlikview-generated URL, which is
It generates a 403 error with the following documentation:
This error (HTTP 403 Forbidden) means that Internet Explorer was able to connect to the website, but it does not have permission to view the webpage.
For more information about HTTP errors, see Help
Can anybody pls help me to get working the google api again? File attached it just doesnt work . It doesnt show the maps and the blobs
I would apreciate any help
vampiros:
First of all, you need to get a API v3 new valid key and place it on the load script, for the variable:
gmap_key = 'xx';
Replace the 'xx' with your new key.
Then you should change the Frame Background Color property with someting like this:
='http://maps.google.com/maps/api/staticmap?center='
&
num(var_mid_lat, '##############', '.', ',' )
&
','
&
num(var_mid_long, '##############', '.', ',' )
&
'&zoom=$(var_zoom)'
&
'&maptype='&var_maptype
&
'&size='&map_size_x&'x'&map_size_y
&
'&key='&gmap_key & '&sensor=false'
Please note that the URL changed and in the end there is not ".jpg" parameter.
Hope this be useful.
Regards
Dear julian.rodriguez and giada.bravi
Thank you very much, the google maps now works.
But there is still a problem:
If you select some values (draw an rectangle over the map), the map doesn't zoom in, like it did before.
I hope u can help me/us.
Kind regards.
Simon
Thank you very much. Nothing but love for you and your kindness
Just one more thing: seems i shredered something.. I cant search for longitude and latitude. My search strings are: zagreb, Hrvatska (city and country). Can yiou pls just check the script below?
let noRows = NoOfRows('GoogleMaps')-1;
for i=0 to $(noRows)
let a=peek('CUSTACCOUNT',$(i),'GoogleMaps');
//let b=peek('LastName',$(i),'Table1');
//let c=peek(‘ProductSold’,$(i),'Table3');
let b=peek('Adresa',$(i),'GoogleMaps');
Data:
LOAD
'$(a)' as [Kupac šifra],
//'$(b)' as LastName,
//'$(c)' as ProductSold,
'$(b)' as Adresa,
subfield([Response/Placemark/Point/coordinates], ',' ,1) AS longitude,
subfield([Response/Placemark/Point/coordinates], ',' ,2) AS latitude
FROM [http://maps.googleapis.com/maps/geo?q=$(b)&output=xml&oe=utf8&sensor=false&key=] (XmlSimple, Table is [kml]);
next i;
Hi giada,
I'm so confused, you're right I've made an error and forgot the center.
It's now perfect, thanks a lot!
Hi
I have tried everything that has been suggested in this thread and still are not getting the map image. Is there anywhere else I should be looking or could somebody attach a known working map with data added as an inline table perhaps. I was thinking that the something was being blocked by our server but tried on home PC and still no image,
Thanks
Dave, please see attachement.
And don't forget to exchange the gmap_key variable value for your own API key, since this key should be unique for each project, according with the Google terms.
Regards.
Thanks for your speedy reply.....afraid that still doesn't show the map
I have checked the license I have and that doesn't seem to be the problem....now I really confused.
I think its time to look at Bing maps or somewhere else.
Thanks
Dave
The weird thing is I have created a Text Field that uses the code that the dynamic link is using and if I put that output into Google it brings up the map.
Any one else experiencing this issue??
Thanks
For what it's worth, ours also stopped working, but by simply removing the '.jpg' from the end of the URL the maps came up again.
This after I had messed and fussed with trying to regen a key for several hours But all's well that ends well. Hopefully this works for you too.
Thanks