topic Google Map Integration in QlikView

Google Map Integration

Tue, 13 Mar 2012 06:04:26 GMT

Hi,

I'm new to QV, using the Personal Edition, I'm trying to integrate Google Maps to our solution. I have attached the PDF which I followed to integrate Google Maps and its not working for me at all. The fields i have got in the expression are Longitude,Latitude and Patient_Registration for that location. Kindly help me on this, I'm stuck up with this nearly from 2 days.

Thanks in Advance

Google Map Integration

erichshiino — Tue, 13 Mar 2012 17:04:43 GMT

Hi,

If you are using an example from QlikCommunity as your reference, your fields should probably be renamed to latitude and longitude (lower case)

Please, check if you don't have problems with decimal numbers as mentioned here:

http://community.qlik.com/thread/23115

Hope this helps,

Erich

Re: Google Map Integration

kamalqlik — Wed, 14 Mar 2012 04:48:41 GMT

Hi pavan ,

Erich is right.Please make sure about the dimension that you are using and that is in the refrence.

If you still have the problem than I am attahing the application that I have worked.

Hope that help you

Re: Google Map Integration

Wed, 14 Mar 2012 06:55:51 GMT

Hi Pavan,

please keep in mind that the white paper is almost three years old. The Google Maps API has changed in the meantime, e.g. you don't need an API-key anymore.

Furthermore be sure to read the updated terms of service of the Google Maps API (e.g. usage limits and commercial use restrictions).

If you post your QVW-file here (with demo data if you are working with sensitive data) we might be able to help you

better.

Otherwise, if you are looking for a commercial solution, I would like to invite you to take a look at our product GlobeQlik (http://lrlikes.com/gq2) which display maps within QlikView easily.

Currently we are using OpenStreetMaps (OSM) as the main background map, but we are working on a new extension object to use more map providers (e.g. Google Maps, OSM, Bing Maps, ...).

Hope this helps,

Wilhelm

Re: Google Map Integration

Wed, 14 Mar 2012 07:08:44 GMT

Hi,

Here I'm attaching the Map Sample qvw file which i was working on. Please tell me describing whats the problem rather than editing the same file and sending me back as I use personal edition. Waiting to hear back soon.

Thanks,

Pavan

Re: Google Map Integration

kamalqlik — Wed, 14 Mar 2012 08:29:06 GMT

Hi Pavan,

I opened your applicaion on my desktop.It is working fine without any change.

I am attaching the screenshot for that.

regards

Kamal

Re: Google Map Integration

Wed, 14 Mar 2012 09:29:27 GMT

Hi Pavan,

it also works on my computer.

Another thing you might try, is load your data into the QVW posted by Kamal.

Regards,

Wilhelm

Google Map Integration

Wed, 14 Mar 2012 11:48:43 GMT

Hi,

I still don't understand y its not working, so i have attached the chart properties' screen shots tab by tab, so that it will give a clear idea of what mistake could have i made in the chart properties as well. I have also shown the dynamic image link what I used for the google maps. Waiting to hear back soon, its really urgent.

Thanks again,

Pavan

Google Map Integration

kamalqlik — Wed, 14 Mar 2012 12:12:12 GMT

Hi Pavan,

I run your same application without any change ...but it is working fine for me.

Re: Google Map Integration

Thu, 15 Mar 2012 04:48:27 GMT

Hi again,

there seems to be an error in your maptype expression.

What get's generated:

http://maps.google.com/staticmap?center=29,77&zoom=5&maptype='=if(isnull(only(maptype)),fieldvalue( '&chr(39)&'maptype'&chr(39)&', 4 ),maptype)'&size=700x700&key=ABQIAAAA0HJ57VTP_SlbhN2l8S_wGRSCC1Qo7o9qRVortWI-RePD7begzxTfJ_AH5jfn1kxWiZEw7ngNoHss2g.jpg

What it shoud look like:

http://maps.google.com/staticmap?center=29,77&zoom=5&maptype=roadmap&size=700x700&key=ABQIAAAA0HJ57VTP_SlbhN2l8S_wGRSCC1Qo7o9qRVortWI-RePD7begzxTfJ_AH5jfn1kxWiZEw7ngNoHss2g.jpg

Another note: Please check, if you can even access this link. Maybe it is blocked by your firewall.

Regards

Wilhelm

Google Map Integration

Thu, 15 Mar 2012 05:32:29 GMT

Maybe the issue is with firewall, I have raised a call to check wth the technical team here who deals with firewall, and hoping to see a positive result.

Thanks all who replied and helped

Google Map Integration

Sokkorn — Thu, 15 Mar 2012 06:24:54 GMT

Hi,

Maybe this one can help you http://community.qlik.com/message/147126

Regards,

Sokkorn

Google Map Integration

Fri, 16 Mar 2012 05:17:12 GMT

Hi all, Finally it worked for me. All I had to do is use https like this https://maps.google.com/staticmap?center=29,77&zoom=5&maptype=roadmap&size=700x700&key=ABQIAAAA0HJ57VTP_SlbhN2l8S_wGRSCC1Qo7o9qRVortWI-RePD7begzxTfJ_AH5jfn1kxWiZEw7ngNoHss2g.jpg instead of http only.. Anyways,many thanks again for all the help and support.

Thanks,

Pavan

Google Map Integration

Thu, 31 May 2012 08:49:17 GMT

Hi,

In what format do the coördinates need to be?

In addition, is there only one format that qlikview can read?

What if my coördinates look like this?

44.667	51.033.298
44.167	51.216.702
8	47
41.333	51
4.4	51.166.698
44.167	51.216.702
44.167	51.216.702

Re: Google Map Integration

Fri, 02 Nov 2012 07:41:38 GMT

Hi all,

Is there any way to change the chart bubble into a shape like any pin point ect...........

thanks in advance