topic Re: Compare two date fields, find the next greater date in QlikView

Compare two date fields, find the next greater date

Mon, 25 Jul 2016 16:06:00 GMT

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

Re: Compare two date fields, find the next greater date

sunny_talwar — Mon, 25 Jul 2016 16:09:45 GMT

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?

Re: Compare two date fields, find the next greater date

Tue, 26 Jul 2016 06:44:08 GMT

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.

Re: Compare two date fields, find the next greater date

MayilVahanan — Tue, 26 Jul 2016 07:01:48 GMT

Are you looking like attachment?

Re: Compare two date fields, find the next greater date

Tue, 26 Jul 2016 07:04:33 GMT

Thank you... this looks good!!