Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to create a dashboard that does an automatic location lookup based on a coordinate system using intervalmatch.
For example, I have a location with the following coordinates: X,Y = (5.3,4.1)
And I have a lookup table that contains all the coordinates with different location names:
X_Start, X_End, Y_Start, Y_End, Location
1, 2, 0, 2, Entrance
2, 4, 2, 3, Aisle
4,6,3,5, Driveway
When I do my interval match for the given coordinates, I would want the output to be "Driveway".
Here is the script I used but it didn't really work.
MatchX:
IntervalMatch([XCOORDINATE])
LOAD
X_START,
X_END
Resident
Intervals;
Left Join(T2)
LOAD DISTINCT
XCOORDINATE,
X_START,
X_END,
autonumber(X_START&'|'&X_END&'|'&'X_KEY') as X_KEY
Resident MatchX;
drop tables MatchX;
MatchY:
IntervalMatch(YCOORDINATE,X_KEY)
LOAD
Y_START,
Y_END,
X_KEY
Resident Intervals;
Left join (T2)
Load distinct * Resident MatchY;
Drop tables MatchY, Intervals;
I also tried this solution which didn't work either::
https://community.qlik.com/t5/QlikView-App-Dev/Match-Coordinates-in-between-2-values/td-p/345344
Perhaps like this: