Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Google Maps Integration Gone? Anyone else?

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

http://maps.google.com/staticmap?center=38.097986,-106.0454515&zoom=2&maptype=&size=800x300&key=xx&....

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

35 Replies
Anonymous
Not applicable
Author

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

Not applicable
Author

Would be great if  you can the steps involved to integrate the map in Qlikview ??

Thanks

sathia.rams@yahoo.in    

Not applicable
Author

In reply to the last two questions:

 

1 - Get a key for Google Maps V3

 

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

 

2 - Fix the load script

 

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

 

3 - Set the map color so that it displays

 

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.

anuradhaa
Partner - Creator II
Partner - Creator II

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

Not applicable
Author

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.