topic When we can use IntervalMatch funcation in QlikView

When we can use IntervalMatch funcation

Fri, 04 Mar 2011 14:53:05 GMT

Can any one explane me about IntervalMatch funcation.

When such case we can use IntervalMatch .

Please explane me with qvw exemple file.

Regards

Ashish

suniljain — Fri, 04 Mar 2011 14:59:33 GMT

Dear Ashish,

One real life scenario is

suppose I have transation data on date basis and currency data on start date and end date basis.

to find the currency rate between startdate and Enddate of transaction date you can use interlval match .

johnw — Sat, 05 Mar 2011 02:11:22 GMT

Here's an example finding the price of an item on the date of a sale based on the client and contract start and end dates.