Hello Qlik Experts,
I own a table with several thousands Work Requests (WR), corresponding dates and status.
A sample for two separate WR (#124 and #125) is provided in the attached Excel file.
I need to implement the following logic:
1. Check column "WR Status"
2. Find all "CLOSED" statuses
3. Find WR number corresponding to "CLOSED" status
4. Find all records corresponding to closed WR and ignore these records going forward (in my sample ignore all records for WR #124 in lines 1,2,3,4,5,6,7,8)
5. For remaining WRs find the oldest date of status update for each WR in the column "WR status updated on"
6. Calculate WR actual age for each WR by substituting the date when WR was reported first time ("WR reported first time on") from the oldest status update date ( "WR status updated on")
I have some experience with Qlik scrips and SQL, but really need your advice with the implementation of this pseudocode.
Practical help/advice/guidance or your review of the logic used in the pseudocode will get all my attention and will be very much appreciated.
