How to get Closest Date

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have Table(Table1) and need to get the column "State" from Table 2. I want the state with the same Number and the closest Date2 from Date 1 but can't get it right.

Here's an example:

Table1:

Number Date1

1 16/08/2016

1 21/08/2016

1 26/08/2016

2 07/08/2016

2 16/08/2016

3 07/08/2016

3 12/08/2016

Table2:

Number Date2 State

1 10/08/2016 A

1 14/08/2016 B

1 20/08/2016 D

1 28/08/2016 B

2 05/08/2016 C

2 10/08/2016 C

2 20/08/2016 B

3 04/08/2016 A

3 06/08/2016 A

3 14/08/2016 B

3 28/08/2016 C

Final Table:

Number Date1 State

1 16/08/2016 B

1 21/08/2016 D

1 26/08/2016 B

2 07/08/2016 C

2 16/08/2016 B

3 07/08/2016 A

3 12/08/2016 B

Regards,

Francisco.

Re: How to get Closest Date

sunny_talwar — Fri, 23 Sep 2016 16:10:55 GMT

See my response here:

How to get Closest Date

Re: How to get Closest Date

antoniotiman — Fri, 23 Sep 2016 16:41:06 GMT

Hi Francisco,

see Attachment.

Regards,

Antonio

Re: How to get Closest Date

Mon, 26 Sep 2016 12:35:35 GMT

Thank you!

topic How to get Closest Date in QlikView

How to get Closest Date

Re: How to get Closest Date

Re: How to get Closest Date

Re: How to get Closest Date