Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Script calculation

Hi,

I have 3 files with data in multiple currencies and 1 file with the Currency Rates.

I would like to have the script to look at the Currency field in the data table(s), find the corresponding Rate in the Currency Table and calculate the Euro rate, the have the result of that calculation show up as a column.

I'm still pretty new at this, so can anyone give me some pointers on how to do this? So far, all my attempts have failed.

Would be much appreciated.

2 Replies
Employee
Employee

Re: Script calculation

Check this: Currency Conversion

Not applicable

Re: Script calculation

If you have the Currency rate on each day, just add the currency rate based on your transaction date with ApplyMap.

Please post some sample data

Community Browser