Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
bobbyn4u
Contributor III
Contributor III

Currency Conversion

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 CodeSupplier NameCurrencyTotal Amount
32533ABC.comIDR21049525052.72
34403XYZ limitedCLP5950743241
34124Company1IDR4306139614
16049Company2KRW2501579052
102Company3INR2164367253.89
2 Replies
chrismarlow
Specialist II
Specialist II

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.

el_aprendiz111
Specialist
Specialist