PFA document would help you.
I started to do the interval match, and the first two IDs work as expected.
But then i noticed some duplication in your data that don't match the desired results.
For example, for 1000E2USdd 16890-000 , you have two intervales for 9/1/2014-> 12/31/9999 with 2 different values. See below
And when i check the desired result it doesn't quite make sense
How did you associate 9/26/2014 to line 11 and 10/15/2014 to line 14 ??
Ok - i still see an unexpected 'desired output' in your spreadsheet.
There are 2 records with invoice dates below
To match those 2 records to specific intervals we have the following possible intervals for A and B
According to the above ID=A and InvoiceDate=10/16/2014 would map to $400 and ID=B and InvoiceDate=08/01/2014 would map to 240$ . However your expected outcome is this ???
When I applied the interval match in QlikView i got the expected result of
If you agree with me, below is the load script for this and attached is the QVW. The solution uses the 'extended' interval match syntax to not only match the interval but another identifier as well... in this case ID.
Date(InvoiceDate) as InvoiceDate
(ooxml, embedded labels, table is [Table 1]);
Date([Start Date]) as [Start Date],
Date([End Date]) as [End Date],
(ooxml, embedded labels, table is [Table 2]);
inner join IntervalMatch (InvoiceDate,ID) LOAD [Start Date], [End Date],ID Resident StartEnds;
Sample.qvw 188.0 K