Using Google Maps with QlikView

[#1]

I followed the instructions on this whitepaper to include Google Maps in my document and it works http://global.qlik.com/uploadedfiles/Whitepapers/whitepaper_how_qliktech_uses_qlikview_google_maps.p....

My question is I seem to be having a problem getting the latitude/longitude coordinates to center correctly on the map. I'm using version 8.5 so I have to overlay the chart on the map, which I've done without much difficulty. The problem seems to be to get the chart to center correctly on the map. I've attached a simple example of what I'm getting. Has anyone used the whitepaper example to implement Google Maps?

Thanks.

[#2]

Of course Rob,i have just to reduce the database which give the number of people who lives in a city & works in another city (1,2 M of couples).

Maybe tomorrow.

Jean-Jacques

[#3]

Here we go Rob

I reduced the app limited with flow > 50 and also modifed the original structure :

- origin : city where people live

- destination : city where people work

- number of commuters

I transformed this structure to use QV with a duplication of line.

I see a lot of improvement but I don't know if it's possible with QV :

- get different size of the arrow depending of the value of the flow

- give different color for each origin, ...

The source is from INSEE (french census bureau, data are real & free)

Jean-Jacques

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/5545.FluxDT.rar:550:0]

[rwunderlich]

Thanks! Great stuff!

-Rob

[#5]

Thanks. Looks great. Sorry I haven't responded earlier (been laid up after surgery). Anxious to try other applications with this.

[#6]

Hate to keep bugging but do you know if there's anyway to make the map respond to user interaction? In otherwords give the user the ability to zoom in or out or pan around the displayed map?

Thanks.

[#7]

Hi,

I think you have to develop some macro using the GoogleMaps Api. I' m not a specialist in development and I never seen in QV some advanced add on from Google Maps (The Pan, The zoom, access to streetview, ...). I'm trying now in France to associate some company to link QlikView with GoogleMaps specialist. All the improvement we can done will be a great step.

Jean-Jacques

[#8]

Hi Rob,

Seems like you may have some expertise in using maps with qlikview. I am having some trouble with it and was wondering if you could offer some assistance. I posted a question on the forum at the following link:

http://community.qlik.com/forums/p/31359/120645.aspx#120645

Any help would be greatly appreciated.

[#9]

I've examined the map with the flow areas and find it very creative. Can you explain the data elements of your flow file?

Is it:

ValFlux - outbound volume

IdFlux - Inbound volume

DC is the locations

What are the DepO, DepD & Dir?

[#10]

Yep, if i remember well

Each flow as an id = IdFlux

Each flow is display in 2 rows :

- first is the origin of the flow

- second is the destination

So field Dir = 'O' is for the origin and Dir='D' is for the destination

Dc is the Id location for french cities. So if Dir = 'O' DC = the city where people live, if Dir = 'D' then DC = the city where people work

Then ValFlux is the value of flow = number of people who live in a city and work in another city.

This structure seems tricky but it was built just to display the arrow in the map. I didn't find out other way.

My initial data structure was one row by flow (so City origin, City destination, Flow)

To end, the fields DepO & DepD are the id of french "departement" ( The 2 first digits of DC). DepO for origin, DepD for destination. Departement is a set of cities

I used this fields to filter the data. For example, If i want to display where people living in the departement = 75 are working, if select '75" in a listbox.

Hope it helps you

JJ

[#11]

This was a great help. Thanks. I modified it slightly to show multiple legs in a sequence. Still need to do some work on getting the data to flow, but its easier due to your assistance.