Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor III

Geoanalytics

I wonder if anyone had some time to help me out as I'm very new to Geoanalytics.

I have an excel file with almost 50k towns of Ireland with their longitude and latitude coordinates.

I also have patient address data (only town and county) and GP data (town and county).   Patients are associated with GP's.

I want to be able to use my long and lat data to plot (point layer) where in Ireland GP's reside and also where in Ireland each GP sends patients from.

Can I use the same file for both addresses?  How on earth do I even start going about his 😂  

As always....any and all help is much appreciated.

Hope everyone is staying safe.

Ciara

Labels (2)
1 Reply
Highlighted
Valued Contributor II

Re: Geoanalytics

It's not a lot of records so I would combine them

Join the patients' table into the doctors

Then bring in two sets of lat and long (one for doctors and one for patients)

Fields in resulting table:

- patient name

- doctor name

- patient town

- doctor town

- patient town lat

- patient town long

- doctor town lat

- doctor town long

in your geovisualization, doctors and patients will be on separate layers