Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Help with Plotting Coordinates as Map

I have converted many full addresses into coordinates of the formula [x, y] via a different tutorial and I know thy are correct. I can copy paste and single one of them into google and it comes up with the correct location. Following a different tutorial, I ended up with the following script (the stuff I added bracketed in red):

Companies and Coordinates.PNG

From here, I went into my sheet and opened a map and added coordinates (with no little black earth next to the name) as a dimension. For some reason, nearly all of my coordinates are popping up in Antarctica. What am I doing wrong here? I've attached a simplified version of my document. I really appreciate any help I can get on this. Bad map also shown below:

ItsTooColdHere.PNG

1 Solution

Accepted Solutions
MK9885
Master II
Master II

That's cus you pre-created coordinates.

Your Coordinates are wrong....

It should be like below

TestGeo
ACS Industries Inc[-71.4816344, 41.9293994]
Alden Medical LLC[-72.6257684, 42.0953890]

First you should have Longitude and then Latitude

FYI, I'm using Google Map extension and not the Qlik default map.

To use google map you'd need your own API key as a developer but in your case you can use default Qlik Maps

Untitled.png

Better Use Latitude and Longitude as separate fields then make a Geopoint out of it to create Coordinates.

Something like below in your script if you have below 2 fields

GeoMakePoint( Lattitude, Longitude) as GeoLocation

And use GeoLocation as a Layer in Map

View solution in original post

2 Replies
MK9885
Master II
Master II

That's cus you pre-created coordinates.

Your Coordinates are wrong....

It should be like below

TestGeo
ACS Industries Inc[-71.4816344, 41.9293994]
Alden Medical LLC[-72.6257684, 42.0953890]

First you should have Longitude and then Latitude

FYI, I'm using Google Map extension and not the Qlik default map.

To use google map you'd need your own API key as a developer but in your case you can use default Qlik Maps

Untitled.png

Better Use Latitude and Longitude as separate fields then make a Geopoint out of it to create Coordinates.

Something like below in your script if you have below 2 fields

GeoMakePoint( Lattitude, Longitude) as GeoLocation

And use GeoLocation as a Layer in Map

Anonymous
Not applicable
Author

When you're right you're right! Separating the coordinates into 2 separate fields resolved the problem and allow qlik to piece them together separately on it's own. Didn't even have to do any script editing. Thanks.