Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
krishna20
Specialist II
Specialist II

Google map Integration

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

1 Solution

Accepted Solutions
JonnyPoole
Employee
Employee

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.

google.PNG.png

View solution in original post

5 Replies
JonnyPoole
Employee
Employee

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--
Rampur31.4506377.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.

JonnyPoole
Employee
Employee

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)

krishna20
Specialist II
Specialist II
Author

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

JonnyPoole
Employee
Employee

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.

google.PNG.png

View solution in original post

vikasmahajan
Champion
Champion

Please Follow this link

Google Map for India

Vikas