Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

IntervalMatch (Extended syntax)

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

Tags (1)
1 Reply
MVP
MVP

IntervalMatch (Extended syntax)

Try this:

INNER JOIN INTERVALMATCH (OrderDate, Val)

LOAD

          DateFrom,

          DateUntil,

          Val

resident RateData;

Community Browser