topic Re: Re: Google map Integration in QlikView

Google map Integration

krishna20 — Tue, 02 Sep 2014 09:57:23 GMT

Dear Community,

I tried for Google map with the help of white paper and got result. I need to extend this map further. Like, when i click on the city names , the area should be highlighted with a bubble. when i move cursor on the particular area, the data should be shown(data i have not inserted now).I need to show the expression details should pop-up.How can i show only three countries which i need not whole world map.

Can anyone help me out .

Thanks & Regards

Kalyankrishna

Re: Google map Integration

JonnyPoole — Tue, 02 Sep 2014 17:59:21 GMT

hi , i noticed you have some NULLs and some strange data (below) . I would suggest filtering that out of your data set or fixing with some real data

Aurangabad	-	-
Bilaspur	-	-
Chandigarh	-	-
Durgapur	-	-
Noida	-	-
Rampur	31.4506	377.644
Udaipur	-	-

Once you've excluded the data set, try this version attached. it seems to work . there were a few changes on the chart properties i borrowed from another working example.

Re: Google map Integration

JonnyPoole — Tue, 02 Sep 2014 18:06:03 GMT

Also , when you want to show more in the tooltip , modify the 3rd expression.

Right now it just has : only(City) , but change it to something like:

='City: ' & only(City) & chr(10) & 'Revenue: ' & sum(Sales)

Re: Re: Google map Integration

krishna20 — Wed, 03 Sep 2014 06:10:49 GMT

Hi Poole,

Thank you for your valuable reply.

I need to show only one country in my dashboard with zoom. I'm getting my country at two places, it may be issue of latitudes and Longitudes? I need to show the Pointed out city as balloon (Parachute model).

please find the below attached file and guide me further.

Regards

Krishna

Re: Re: Re: Google map Integration

JonnyPoole — Thu, 04 Sep 2014 01:27:33 GMT

So here is the QVW . I added a bookmark to filter out the cities that have bad coordinate data. The bad coordinate data is throwing the map off wildly, so it only works if you filter out the bad data.

What you will want to do is correct the lat and long data for the removed cities in the data source, or remove the cities . then reload.

Re: Google map Integration

vikasmahajan — Thu, 04 Sep 2014 10:37:31 GMT

Please Follow this link

Google Map for India

Vikas