Previous Sale Date for Each Unit Sold

[NormanStanleyBadger]

Hello,

Is it possible to return the previous sale date for each unit sold as per the table below? I would like to calculate the average number of days between purchases for each customer. Thanks in advance. NSB

SKU	SKU Sale Date	Customer Previous Sale Date
SKU1	24/08/2023	22/08/2023
SKU2	22/08/2023	15/08/2023
SKU2	15/08/2023	etc

[Digvijay_Singh · Accepted solution]

You would need peek/Prev Qlik functions to create your new column, lots of help over here - 

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/use-inter-reco...

[NormanStanleyBadger]

Thank you. I will do a bit of digging and report back, if I can find a solution that fits my needs.