topic Re: Currency within 2 dates in QlikView

Currency within 2 dates

Anonymous — Fri, 14 Nov 2014 10:36:59 GMT

Dear All,

I have two datasources. One of them has invoice number, invoice date, amount and currency fields. The other one has currency, exchange rate, start date, expiration date. I have make a connection with concatanation of currency and date between two table.

Of course the invoice date must fall within 2 dates and give me back the right exchange rate.

Looking forward to having a solution.

Thank you

Roberto

Re: Currency within 2 dates

datanibbler — Fri, 14 Nov 2014 10:39:47 GMT

Hi Roberto,

that's a clear case for IntervalMatch() - you have to match your invoice_date to an interval during which a specific exchange_rate is valid (defined by a start_date and an end_date)

=> Just what IntervalMatch() does.

HTH

Best regards,

DataNibbler

Re: Currency within 2 dates

Gysbert_Wassenaar — Fri, 14 Nov 2014 10:43:21 GMT

You can use the intervalmatch function to match a date in one table with an interval in another. See this document: IntervalMatch and Slowly Changing Dimensions

Re: Currency within 2 dates

Anonymous — Fri, 14 Nov 2014 12:56:52 GMT

Thank you