Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
gui_baudouin
New Contributor

Retrieve the corresponding date

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).

screenTest.PNG

 I attached a small test file.

Thank you in advance for your help,

Cordially

1 Solution

Accepted Solutions
arpitkharkia
Contributor III

Re: Retrieve the corresponding date

Hi,

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

2 Replies
arpitkharkia
Contributor III

Re: Retrieve the corresponding date

Hi,

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

gui_baudouin
New Contributor

Re: Retrieve the corresponding date

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