Qlik Community

Qlik GeoAnalytics Discussions

Discussion Board for collaboration regarding Qlik GeoAnalytics.

mikecrengland
Contributor III

GeoAnalytics Routes help

Hello -

I'm trying to learn how to use Routes with the GeoAnalytics connector and am having some issues.

I've loaded a simple table:

   

ROUTEIDStartEnd
1'[-118.243685,34.052234]''[-87.629798,41.878114]'
2'[-111.891047,40.760779]''[-84.387982,33.748995]'
3'[-122.332071,47.606209]''[-99.480324,27.530567]'

I've also tried

   

ROUTEIDStartEnd
1Los Angeles, CAChicago, IL
2Salt Lake City, UTAtlanta, GA
3Seattle, WALaredo, TX

When I try to load the data with this configuration:

2018-02-28_8-37-04.png

I get the following error:

2018-02-28_8-37-41.png

What am I doing wrong?

Thanks,

mike

1 Solution

Accepted Solutions
Employee
Employee

Re: GeoAnalytics Routes help

Hi Michael,

It's the Geometry type field that needs more info, in both places:

City state is "Location Named Point"

'[-118.243685,34.052234]' is "Point"

Long Lat in separate fields is "Latitude and Longitude Point"

See the attached app

Thanks,

Patric

3 Replies
mikecrengland
Contributor III

Re: GeoAnalytics Routes help

I actually got it to run using City, State, but got the following error on the load:

2018-02-28_10-59-54.png

Is City, State not a 'named point'?

Employee
Employee

Re: GeoAnalytics Routes help

Hi Michael,

It's the Geometry type field that needs more info, in both places:

City state is "Location Named Point"

'[-118.243685,34.052234]' is "Point"

Long Lat in separate fields is "Latitude and Longitude Point"

See the attached app

Thanks,

Patric

mikecrengland
Contributor III

Re: GeoAnalytics Routes help

Patric, you are the man!!

2018-02-28_11-22-41.png

Community Browser