Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

coronetspa
New Contributor II

Currency within 2 dates

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

Tags (1)
1 Solution

Accepted Solutions
datanibbler
Esteemed Contributor

Re: Currency within 2 dates

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

3 Replies
datanibbler
Esteemed Contributor

Re: Currency within 2 dates

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

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


talk is cheap, supply exceeds demand
coronetspa
New Contributor II

Re: Currency within 2 dates

Thank you

Community Browser