topic Re: how to get the values based on the dates? in QlikView

how to get the values based on the dates?

Somasundaram — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Please find the attached excel sheet, I have provided the Input, Mapping table and Out put , Based on the Mapping table I need to match the date field. Please do the needful. Thanks in advance

Mapping table Table
Date	ITC Day
1/18/2017	1/25/2017
2/15/2017	2/22/2017
3/20/2017	3/27/2017
4/17/2017	4/24/2017
5/17/2017	5/24/2017
6/19/2017	6/26/2017
7/18/2017	7/25/2017
8/18/2017	8/25/2017

input date

date

1/10/2017

1/1/2017

1/10/2017

1/14/2017

1/16/2017

1/17/2017

2/10/2017

2/12/2017

2/14/2017

2/15/2017

2/16/2017

2/17/2017

2/18/2017

3/1/2017

3/10/2017

3/11/2017

3/12/2017

3/20/2017

4/1/2017

4/12/2017

4/16/2017

Output
date	ITC Day
1/10/2017	1/25/2017
1/1/2017	1/25/2017
1/10/2017	1/25/2017
1/14/2017	1/25/2017
1/16/2017	1/25/2017
1/17/2017	1/25/2017
2/10/2017	2/22/2017
2/12/2017	2/22/2017
2/14/2017	3/27/2017
2/15/2017	3/27/2017
2/16/2017	3/27/2017
2/17/2017	3/27/2017
2/18/2017	3/27/2017
3/1/2017	3/27/2017
3/10/2017	4/24/2017
3/11/2017	4/24/2017
3/12/2017	4/24/2017
3/20/2017	4/24/2017
4/1/2017	4/24/2017
4/12/2017	4/24/2017
4/16/2017	4/24/2017

Re: how to get the values based on the dates?

MarcoWedel — Tue, 08 May 2018 22:02:05 GMT

please elaborate

Re: how to get the values based on the dates?

jheasley — Tue, 08 May 2018 23:17:00 GMT

first step::::

DateMap:

Mapping Load

Date("Date"),

ITCDate

From [filepath];

second step::::

DateLoad:

Date

ApplyMap('DateMap',Date("Date"),-99) as ITCDate

From [filepath]

Re: how to get the values based on the dates?

Somasundaram — Wed, 09 May 2018 05:04:51 GMT

Using apply map how can i get the less than value. here, input date need to match with less than date of mapping table.

Re: how to get the values based on the dates?

Somasundaram — Tue, 24 Jul 2018 13:19:49 GMT

Using Interval match,I could get the above date.

Thanks all for your replies.