First Selected Value - Second, Third, Fourth, etc values
I'm working to keep track of the days my trainees have each of their training shifts. Each trainee is expected to complete a certain number of training shifts and our daily shift history reload contains all shifts published 'tomorrow' so that Qlik is always receiving the most up to date schedule prior to that day starting.
This is the desired output.
I've pulled the first shift date using this expression:
Am I going about this the right way? For some of my users, their records pull up just fine and in order. For some of the people, it will show a record for Shift 1, 2, nothing for shift 3, 4, then have a record for shift 5. I don't really understand how it can know what record 1, 2, and 5 should be without knowing what records 3 and 4 are.
Thank you for the direction, happy to provide any further details.