topic Re: Currency Conversion in QlikView

Currency Conversion

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All

I have two files,in file-1 I have currencies like CAD,EUR,GBP,KRW,MYR,USD and

in file-2 I have BRL,CAD,EUR,GBP,HUF,PLN,RON,TRY,USD.

Currencies which are extra in file-2 are in USD in file-1,now how can I convert those local currencies in file-2 into USD and keep remaining currencies same so that I can get an expression Sum(Net) where Net is a field in file-2

Re: Currency Conversion

jonathandienst — Tue, 07 Feb 2017 13:11:47 GMT

That's a littel vague to work from. I suggest that you prepare a sample of file1 and file2, and give specific examples of the results you would like to achieve.

Re: Currency Conversion

Anonymous — Tue, 07 Feb 2017 14:06:38 GMT

Hi Jonathan

Attached a sample file.Here,sheet-1 is file-1 in which India is shown in USD but the corresponding sale for same site is shown in INR in sheet-2,but in output in pivot table I need to convert INR to USD and show the corresponding value,similarly for Brazil.

Re: Currency Conversion

jonathandienst — Thu, 09 Feb 2017 05:40:26 GMT

And where are the exchange rates for the conversion?

Re: Currency Conversion

Anonymous — Thu, 09 Feb 2017 15:22:35 GMT

I need to take them from Google,I am not sure how can I do this