Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have POs that come into the qlikview application in different currencies and I want to show the purchase order price in US currency (i.e. $) in my charts and tables. How to convert the value of different currency to become dollar? Is there any conversation? Below is the sample data.
Supplier Code | Supplier Name | Currency | Total Amount |
32533 | ABC.com | IDR | 21049525052.72 |
34403 | XYZ limited | CLP | 5950743241 |
34124 | Company1 | IDR | 4306139614 |
16049 | Company2 | KRW | 2501579052 |
102 | Company3 | INR | 2164367253.89 |
The QlikView bit should be fairly straightforward, but more importantly you would need to know what your users understood by conversion to dollar, i.e. what FX rate are they expecting to be used?
So if the PO are for separate dates (information not in your request) users may expect conversion at that dates rate, or a month-end rate for the month of transaction, or a current rate (in something that refreshes daily say). Organizations then generally have official sources of rates that they would choose to apply - from Reuters for example.
If you are just trying to do something quick & dirty then you could get sample current FX rates from Google & apply them to each row by joining/ApplyMap & calculating.