topic Google Maps Geokey in QlikView

Google Maps Geokey

Mon, 21 Nov 2011 19:23:28 GMT

Hi guys,

I've been trying to figure out how to get the google maps to work and I'm a bit stuck at the moment. I am using the Sales Managment Demo from qlikview as a reference

I have used a PL\SQL script to gather the Long and Lat for each address but when I select a region (Pennsylvania for example) not all of the customers are shown on the map even though they have sales. I end up with the map correctly centered on the region where the coordinates are but not all of the locations are shown.

Example:

Even though their are 4 customers in this area that have sales in the selected time period, I get only one dot but notice how the map is centered around the coordinates of the addresses involved.

I have attached the qlikview file so that you can examine the settings.

Thanks

Paul

Google Maps Geokey

Mon, 21 Nov 2011 20:42:06 GMT

I see a couple of problem.

1) It's better 2 split the data in 2 tables : the customer (with GeoKey field) and the coordinates (GeoKey, Long , Lat).

Howhever, you can replace the sum in long/lat expression by an avg to prevent the summation of long/lat.

2) The link between geokey and State seems to me strange. I'm not a specialist of the USA geography. But when I clik on Florida, I have location in Massachussets !

Hope it helps you

Google Maps Geokey

Mon, 21 Nov 2011 21:00:42 GMT

Thanks Jean-Jacques!!

Suggestion #1 works like a charm!

for #2, this was an earlier revesion and I had some mixing of the bill\ship address by accident.

Thanks again!