Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Google Maps Geokey

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:

Capture.PNG

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

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Google Maps Geokey

Hi

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

JJ

2 Replies
Not applicable

Google Maps Geokey

Hi

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

JJ

Not applicable

Google Maps Geokey

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!