Discussion board where members can get started with QlikView.
I have a table with orders details, with amount in $.
Another table with dates and Euro rates per date.
I would like to calculate the amount in Euro in the load script.
For each order, calculate the amount in Euro, and add the calcuated field in the script.
Would appreciate your help.
LOAD Date as RateDate,
LOAD Date as BacklogDate,
Balance/EURRate as BalanceEUR
Go to Solution.
You can use the lookup function in the script:
Balance/ lookup('EURRate','RateDate',Date,'Currency Rates') as BalanceEUR
or use your currency rates as Mapping table:
Mapping LOAD Date as RateDate,
Balance/ applymap('Currency Rates',Date) as BalanceEUR
I like the first solution as it will apply for having more currencies.
Thank you for your prompt reply!
i'll try it. Although it looks a bit complicated for me to understand,
since i'm just beginning...