Qlik Community

GeoAnalytics

Discussion Board for collaboration regarding Qlik GeoAnalytics.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
JZabor
Contributor
Contributor

Find Closest Geographic Location - Two Sets of Data

Hello Qlik Community,

@Patric_Nordstrom 

I am currently working through a new build and the goal is to compare two locations (data sets) based on Zip Code, but the crux is that I may have a Zip Code in Column A, but not in Column B. Please note that I also do have coordinates available for both points (column A latitude/longitude, column B latitude/longitude)

I want to be able to provide the nearest zip code to Column A from Column B 

Column A
01001
01005
01105

Column B
01002
01005
01105

Outcome:
01001 -> 01002
01005 -> 01005
01105 -> 01105

Thank you

Labels (2)
1 Reply
Patric_Nordstrom
Employee
Employee

The challenge is that the SSE can only work with one inline table as input. A workaround is make a csv temp table.

Pls see the GeoOperations CSV example.qvf  at:

https://community.qlik.com/t5/Qlik-Sense-Documents/GeoOperations-Examples-Qlik-GeoAnalytics/ta-p/175...

 

Thanks,

Patric