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
Hi Noah,
I have used V2 "gmap_Key='xx' " but now its is not working. Can you pls help me how to get the gmap key for V3 from Google?
Also can you explain me the step by step process of how this script is working?
Thanks & Regards,
Nandha
Would be great if you can the steps involved to integrate the map in Qlikview ??
Thanks
In reply to the last two questions:
You'll need an API key for Google Maps V3. I'm not going to document how to get one
here, there's plenty of documentation in Google. Start here. https://developers.google.com/maps/documentation/javascript/tutorial#api_key
Older load scripts with the V2 key do not require a specific
key. However, new ones do. (I've seen stuff on the web saying they
don't, but go ahead and use one.)
In the load script, on the Map Data tab, replace gmap_key
= 'xx';
with
gmap_key = ' (INSERT YOUR GMAP KEY GOOGLE V3 here';
and reload
The display of the map is controlled by the Color aspect of
the object.
1 - Make sure the transparency is set to zero percent, and
2 - replace the Dynamic Image text with the formula below:
='http://maps.googleapis.com/maps/api/staticmap?center='&var_mid_lat&','&var_mid_long&'&zoom=$(var_zoom)'&'&maptype='&var_maptype&'&size=800x300'&'&key='&gmap_key&'&sensor=false'
That's all there is to it.
Hi,
I have the same question and i have below expression ,
='http:maps.googleapis.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 & '.jpg'
Pls tell me how can i fix this?
Thanks
Hi,
I am getting download failed while reloading the script.
let noRows = NoOfRows('Table1')-1;
for i=0 to $(noRows)
let a=peek('createdOn',$(i),'Table1');
let b=peek('stateID',$(i),'Table1');
// let c=peek(‘postalcode’,$(i),'Table1');
let d=peek('countryId',$(i),'Table1');
let address=peek('city',$(i),'Table1');
Data:
LOAD
'$(a)' as createdOn,
'$(b)' as stateID,
//'$(c)' as postalcode,
'$(d)' as countryId,
'$(address)' as Address,
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=xyz] (XmlSimple, Table is [kml]);
next i;
Please help me ASAP.
while relaoding I am getting download failed.