Above is my sample data. I want to be able to track test results by user (ID) within a time period.
If they fail the first time the 12 month review period begins.
On a second failure, they should be identified as 'Noted' and the 12 month review period starts over.
An additional failure within 12 months of 'Noted' should identify them as 'Review'.
I'm new to Qlikview, and would like any suggestions on how this could be scripted on my load to identify these phases per user while accounting for the time period as well.