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.
