Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
JP281990
Contributor
Contributor

QGA Closest Operation - Distance and Route by Car/Truck - Not Returning Expected Results

Experts - 

I am attempting to use the Closest function via Car to calculate distances of many customer locations to a much smaller number of manufacturing locations. I am really looking for just driving miles, so that I can take into account less favorable locations in terms of highway access that distance by bird would not account for. 

I can get the Closest function to work as expected when I mark my distance type as "Bird", but when I run Closest with "Car" - the query doesn't return the proper results. I am using the same inputs in both cases. 

In the example attached, I have created a test example with just one location that I am trying to map back to 4 manufacturing locations to highlight the problem. If you run the scrip by "Bird" you will get 4 distances as expected. When running the QGA script by "Car", only 2 distances are returned - for reasons that are beyond what I can gather. 

Please see attached. 

Any ideas? 

1 Solution

Accepted Solutions
Patric_Nordstrom
Employee
Employee

I would check that start and end points are not too far from a road, that's the most common reason when closest by road is not return. Closest by bird distance always returns a value.

Thanks,

Patric 

View solution in original post

1 Reply
Patric_Nordstrom
Employee
Employee

I would check that start and end points are not too far from a road, that's the most common reason when closest by road is not return. Closest by bird distance always returns a value.

Thanks,

Patric