Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
gui_baudouin
Contributor
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
Creator III
Creator III

Hi,

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

View solution in original post

2 Replies
arpitkharkia
Creator III
Creator III

Hi,

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

View solution in original post

gui_baudouin
Contributor
Contributor
Author

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