Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2018-04-09 05:36 AM

exchange rate matching and calculating

Hello,

I have an issue, where I tried to combine for quite a while but I dont get it work.

We have an overall currency table (with a curdoc rate). Additionally I have several data tables (i.e. WriteOff_Details, Invoice_Details) where I need to calculate the EUR-Value. We want this as additional field (or predefined formula in script, which calculated when the field is used in a table) but the main Currency Table must remain.

There are two important issues:

All tables have one date but the currency table has a valid_from and a valid_to field.

All tables have Landcode (UK, US,...) which is the second parameter to get the correct currency.

How can I reach, that Write-off from 15.02. in UK is taking the rate in GBP from 01.02. until 28.02.?

529 Views
0 Likes
0 Replies