IntervalMatch (Extended syntax)

Sat, 05 May 2012 13:54:15 GMT

I hope someone can help me with the command IntervalMatch.

I have salesorders in currency, I want to convert then to EURO's.

So I have a currency and a amount.

Also I have the count rate per currency with a date from / until.

Problem:

The USD currency come twice (orderline 2) because the rate has change from 1.25 till 1.29 per 1th april 2010.

The orderline has an orderdate from 15th february so only rate 1.25 must I have.

See the attachment.'Script IntervalMatch.txt'

I am curious wath the solution is for this problem.

Regards,

Alfred Hamers

swuehl — Sat, 05 May 2012 14:27:22 GMT

Try this:

INNER JOIN INTERVALMATCH (OrderDate, Val)

LOAD

DateFrom,

DateUntil,

Val

resident RateData;

topic IntervalMatch (Extended syntax) in QlikView