topic Re: Google Maps On Qlikview in QlikView

Google Maps On Qlikview

dseelam — Sat, 16 Nov 2024 02:43:11 GMT

Hello Folks,

I did everything as recommended to develop Qlik Maps on DB but couldn't get through, Something am missing please check attachments.

I have a registered API key from google cloud platform

Re: Google Maps On Qlikview

Frank_Hartmann — Fri, 16 Aug 2019 19:19:58 GMT

see attached

in Color Tab under Dynamic Image you have forgotten to add the variable for your api key to the Expression!

Re: Google Maps On Qlikview

dseelam — Fri, 16 Aug 2019 19:46:56 GMT

Hello Frank,

Thank you

once I entered my key and reload I get this error on maps does it mean key is wrong

Re: Google Maps On Qlikview

Frank_Hartmann — Fri, 16 Aug 2019 20:05:03 GMT

actually not.

strange, because i used your API Key for testing (it was still present under Variables)

and for me it worked without throwing this error (after reloading-> as source i exportetd the whole table as xls and loaded it in QV script)!

did you use this expression under Color Tab --> dynamic Image?:

'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 & '&sensor=false'&'&key='& gmap_key

Re: Google Maps On Qlikview

dseelam — Fri, 16 Aug 2019 20:10:40 GMT

Hi Frank, yes I did used same expression you sent.

Is this some thing to do with URL signing, API restrictions or activating google account to payable ?

Re: Google Maps On Qlikview

Frank_Hartmann — Fri, 16 Aug 2019 20:16:11 GMT

and you have entered you API Key here before reloading?

Re: Google Maps On Qlikview

dseelam — Fri, 16 Aug 2019 20:16:15 GMT

Yes I did !

Re: Google Maps On Qlikview

dseelam — Fri, 16 Aug 2019 20:19:48 GMT

It is so strange when I downloaded your file its working fine once I enter Key in script and reload its throwing an error

Re: Google Maps On Qlikview

Frank_Hartmann — Fri, 16 Aug 2019 20:19:48 GMT

please try to just reload the attached qvw. For me this works fine

Re: Google Maps On Qlikview

dseelam — Fri, 16 Aug 2019 20:22:02 GMT

Yes I reloaded and all data point disappeared and same error strange!

Re: Google Maps On Qlikview

Frank_Hartmann — Fri, 16 Aug 2019 20:22:53 GMT

please upload your country.qvd

Re: Google Maps On Qlikview

dseelam — Fri, 16 Aug 2019 20:27:03 GMT

I see an issue now frank but don't know whats causing it yet.

after reloaded data table is missing maptype field

Re: Google Maps On Qlikview

Frank_Hartmann — Fri, 16 Aug 2019 20:31:09 GMT

no, thats not the issue. even if the maptype filed is not present in table it should work.

please upload your country.qvd

Re: Google Maps On Qlikview

dseelam — Fri, 16 Aug 2019 20:36:19 GMT

Yes I did frank & I was not able to understand how did you manage to get map type in to data table

Re: Google Maps On Qlikview

Frank_Hartmann — Fri, 16 Aug 2019 20:36:30 GMT

please upload the file Country.qvd

not a picture of your script

Re: Google Maps On Qlikview

dseelam — Fri, 16 Aug 2019 20:51:01 GMT

Sorry My bad i misunderstood upload with reload but i am not able to do it due to some technical error attaching a qvd

Re: Google Maps On Qlikview

Frank_Hartmann — Fri, 16 Aug 2019 20:55:36 GMT

just zip the file and upload the .zip file