topic Re: Retrieve the corresponding date in QlikView

Retrieve the corresponding date

gui_baudouin — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

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,

Cordially

arpitkharkia — Thu, 18 Apr 2019 12:12:43 GMT

Hi,

I have attached the solution. I used PEEK() in the backend. I hope this helps!

gui_baudouin — Tue, 23 Apr 2019 08:54:29 GMT

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.

Thank you