topic Interval Match Problem in QlikView

Interval Match Problem

kushalthakral — Sat, 16 Nov 2024 02:32:52 GMT

Hi All

i have a requirement to get results from two tables through interval match function. Below are two sample tables

Date	Brand	Value
5/27/2019	AC	100
7/15/2019	AC	80
1/4/2019	AC	100
8/4/2019	AC	100
4/15/2019	AC	100
4/22/2019	AC	100
4/29/2019	AC	100
5/6/2019	AC	100
5/13/2019	AC	100
5/20/2019	AC	100
3/6/2019	AC	100
10/6/2019	AC	100
6/17/2019	AC	100
6/24/2019	AC	100
1/7/2019	AC	100
8/7/2019	AC	100
7/22/2019	AC	100
7/29/2019	AC	100
5/8/2019	AC	100
12/8/2019	AC	100
8/19/2019	AC	0
8/26/2019	AC	0

SENDER	Sub Brand Name	Amount	Start Date	End Date
AC	A	1000	6/1/2018	12/31/2099
AC	B	200	6/1/2018	12/31/2099
AC	C	300	6/1/2018	12/31/2099
AC	D	4000	6/1/2018	12/31/2099
AC	E	5000	6/1/2018	12/31/2099
AC	F	6000	6/1/2018	12/31/2099
AC	G	7000	6/1/2018	12/31/2099

Based on interval match i need to get Brand wise Amount for a particular date that lies in start date and end date

Thanks

Kushal

Re: Interval Match Problem

rubenmarin — Sun, 08 Sep 2019 21:14:40 GMT

Hi Kushal, intervalmatch is used when there are diferent date ranges to apply values, in this case all rows from table 2 has the same dates, maybe you only need a join to have all values from table 1 splitted into all values from table 2 (where Table1.Brand=Table2.SENDER)

Re: Interval Match Problem

Brett_Bleess — Thu, 19 Sep 2019 14:36:36 GMT

Kushal, likely going to need QVW file on this one in order to get some further comments, as folks likely want to see your data model etc. as well in order to try to see exactly how you are doing things.

Regards,
Brett