topic Currency Conversion in QlikView

Currency Conversion

bobbyn4u — Wed, 27 Dec 2017 12:27:06 GMT

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

Re: Currency Conversion

chrismarlow — Wed, 27 Dec 2017 15:19:45 GMT

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.

Re: Currency Conversion

el_aprendiz111 — Wed, 27 Dec 2017 21:06:30 GMT

Hi,

Currency Conversion