topic Currency Conversion in QlikView

Currency Conversion

rathnam_qv — Tue, 08 Apr 2014 06:28:01 GMT

Hi All,

i have a straight table in that i have some values in Dollars.

My requirement is...i want to create two Radio button on the sheet USD and INR. when i clik on INR the Dollar values should convert as INR and Vice versa

can any one help me.

regards,

rathnam

Re: Currency Conversion

datanibbler — Tue, 08 Apr 2014 06:32:28 GMT

Hi rathnam.qv,

I cannot help you myself, I can just give you a few hints:

- There is a thread around here about conversion_rates from a website called oanda.com - alongside many others - I haven't yet tested it, but
it should be possible.

- Me instead, I use a "fixed" conversion rate that is used for a certain period throughout the company to ensure consistency - that comes via email and I have an Excel file with four columns

- valid_from_date

- valid_to_date

- rate_$_to_€

- rate_€_to_$

=> Then I use the Intervalmatch() function (with a date_field in my data_table) to draw the correct rate for a certain date (that is thereby matched with the periods formed by the valid_from and valid_to in my Excel)

HTH

Best regards,

DataNibbler

Re: Currency Conversion

Tue, 08 Apr 2014 10:09:57 GMT

One possible approach in attachment.

Hope it helps

Darek