Discussion board where members can get started with QlikView.
My goal is to make a calculation between dates of type action = 'C' and dates of type action = 'D' (Date type action C - Date type action D)
I have to retrieve the type C date following the type D date (11/04/2019) and not the date before it (07/02/2019).
I attached a small test file.
Thank you in advance for your help,
Go to Solution.
I have attached the solution. I used PEEK() in the backend. I hope this helps!
Ok thank you so much for your answer.
I implement the code in my case and it works well. I just had to add another field in my Group By instruction because I deal with lot of data.