https://community.qlik.com/t5/QlikView/Difficulty-retrieving-the-previous-or-2nd-latest-date-timestamp/m-p/2469533#M1225908 <P>A manager came to me with a concept in mind:</P> <P>We have a dashboard that shows Outstanding items where most of the items have already been allocated to a technician, the request is to include a new field that shows who previously worked them (Status = Sent to Authorisation or StatusId = 4) on the same Policy.</P> <P>Whether or not an Outstanding item has been allocated to a technician, I would need a new field on the same row showing the above examples Pol-001, SysId-003 to show the previous technician where the Status is Sent to Authorisation or StatusId 4 for the same Policy in this example it would show Tom even though the item was completed by John. And for Pol-002, SysId-003 it would need to show Terry, not Geoff.</P> <P>The same result would be needed if the item was already allocated to a technician and showing as Status 4 on the dashboard showing Outstanding items.</P> Wed, 10 Jul 2024 12:13:47 GMT mike__para 2024-07-10T12:13:47Z https://community.qlik.com/t5/QlikView/Difficulty-retrieving-the-previous-or-2nd-latest-date-timestamp/m-p/2469533#M1225908 <P>A manager came to me with a concept in mind:</P> <P>We have a dashboard that shows Outstanding items where most of the items have already been allocated to a technician, the request is to include a new field that shows who previously worked them (Status = Sent to Authorisation or StatusId = 4) on the same Policy.</P> <P>Whether or not an Outstanding item has been allocated to a technician, I would need a new field on the same row showing the above examples Pol-001, SysId-003 to show the previous technician where the Status is Sent to Authorisation or StatusId 4 for the same Policy in this example it would show Tom even though the item was completed by John. And for Pol-002, SysId-003 it would need to show Terry, not Geoff.</P> <P>The same result would be needed if the item was already allocated to a technician and showing as Status 4 on the dashboard showing Outstanding items.</P> Wed, 10 Jul 2024 12:13:47 GMT https://community.qlik.com/t5/QlikView/Difficulty-retrieving-the-previous-or-2nd-latest-date-timestamp/m-p/2469533#M1225908 mike__para 2024-07-10T12:13:47Z