We have two tables. One table has columns 'ID' and 'Invoice Date'. Another one has columns 'ID', 'Start Date', 'End Date', and 'Price'. The desired output is 'ID', 'Invoice Date', 'Price'. I know this could be done using interval match but having a hard time figuring out how. Any help is highly appreciated. Attached is sample data for your convenience.
No Luck. How to fit in amount is confusing me. I would really appreciate if you can create a quick QVW with attached data and post it back. That will be very helpful in understanding it. Thanks in advance for helping.
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.