Searching a value in a table based on multiple criteria
Hi There,
I am trying to resolve an issue in Qlikview caused by another application. Here is my challenge: I have a table with workorders and a start date and time.
In another table I have workshifts with start/end dates and start/end times and a shift ID.
Per date there are 3 shifts. The first shift is a shift that actually starts the previous day. So shift 1 of Feb 14th starts on Feb 13th 10pm.
From the application there is an error determining the Shift ID for a whole bunch of dates and times resulting in a shift ID of 0.
What I need to do is to get the startdate and starttime from the workorder table and look for the date and time for the appropriate shift.
So I think I need the first shiftrecord where the starttime of the shift is greater then the starttime of the workorder and the startdate of the shift is less or equal then the startdate of the workorder.
I hope this is clear enough and that someone if able to give me a push in the right direction.
