Problem with joining GPS data

galrion82 — Fri, 02 Apr 2010 11:08:49 GMT

Good day

I need to load into QlikView GPS data for my company's car fleet. In the database where the information is stored there are 2 tables that i use:

KmData - it contains the car's position at the moment of the transmission (latitude and longitude) and other details : driver, speed, distance etc.

Locations - a list with points of interest (POI) - our customers addresses defined by 2 points on the map that for ma square with a 100 meters side. It contains (LatitudeMin, LongitudeMin, LatitudeMax, LongitudeMax, LocationDescription.

The data volume is very large (we get about 400000 rows in KmData and 3500 rows in Locations every month).

My problem is that i need to join these 2 tables, but they don't have a common field. The link can be made by checking if a point where a car sent a signal (from KmData table) is inside one of the squares defined in the Locations table. The formula is:

if(LatitudineMin<=Latitudine and Latitudine<LatitudineMax and LongitudineMin<=Longitudine and Longitudine<=LongitudineMax, 1)

I tried using it in a chart, but even with a couple of days loaded, it calculated the chart very slowly.

I think i should calculate this in the script, but i don't know how.

Any suggestion is welcome.

Regards,

Alecs

Problem with joining GPS data

galrion82 — Thu, 15 Apr 2010 09:44:12 GMT

I solved the problem.

I used the IntervalMatch function in the load script and it worked.

Problem with joining GPS data

metin_kahraman — Thu, 24 Feb 2011 15:27:46 GMT

Hi Alecs,

I am dealing with the same problem. Could you please provide your solution ?

Did you find a solution other than applying intervalmatch twice ?

Regards

Metin

topic Problem with joining GPS data in QlikView

Problem with joining GPS data

Problem with joining GPS data

Problem with joining GPS data