Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Compare two date fields, find the next greater date

 

Hi all,

I have a problem:

I want to compare two date fields (date1 and date2) and get the next greater date of field date2.

The relationship between date1 and date2 is 1 to n.

The fields are linked via a Customer ID.

I tried something like that

if(date2>=date2,min(date2))

But this is not correct.

Any ideas about that?

Kind regards

 

 

Philipp

 

Message was edited by: Philipp Schöck I added a small example to explain my problem in more detail. Kind regards Philipp

1 Solution

Accepted Solutions
MayilVahanan

Hi

Are you looking like attachment?

Thanks & Regards,
Mayil Vahanan R
Please close the thread by marking correct answer & likes if you like the post.

View solution in original post

4 Replies
sunny_talwar

I want to compare two date fields (date1 and date2) and get the next greater date of field date2.

I am not sure I understand this part "get the next greater date of field date2". Can you provide a sample to look at this in details?

Not applicable
Author

I try to explain:

The expression 'compared date' should display always the next greater date.

It should look into the field date2, look if there are dates later then in the field date1 and display the smallest of them.

MayilVahanan

Hi

Are you looking like attachment?

Thanks & Regards,
Mayil Vahanan R
Please close the thread by marking correct answer & likes if you like the post.
Not applicable
Author

Thank you... this looks good!!