Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ajsjoshua
Specialist
Specialist

Currency Conversion

Hi all,

I want to convert values in AED to USD based on the daily rates,

Pls suggest...

Regards,

Joshua.

4 Replies
PrashantSangle

do you have any table or file where you maintain conversion rate????

If yes then write if condition

like if(currency_type='AED',value_field*conversion_rate,value_field)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
ajsjoshua
Specialist
Specialist
Author

Dear Prashant,

Thank you for ur suggestion.

Actually we dont have the conversion rate table.Is it possible to update daily with internet.

Regards,

Joshua.

PrashantSangle

chk below thread might help you

Exchange Rate API

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
effinty2112
Master
Master

Hi Joshua,

Try:

[Conversion Rates]:

LOAD [Emirati Dirham],

     [1.00 AED],

     [inv. 1.00 AED]

FROM

[http://www.x-rates.com/table/?from=AED&amount=1]

(html, codepage is 1252, embedded labels, table is @1);

Emirati Dirham 1.00 AED inv. 1.00 AED
British Pound0.2089144.786650
Euro0.2361364.234855
Swiss Franc0.2597693.849578
US Dollar0.2722523.673071
Australian Dollar0.3434442.911681
Canadian Dollar0.3440552.906509
Singapore Dollar0.3727162.683007
Malaysian Ringgit1.1666760.857136
Indian Rupee17.5160090.057091
Japanese Yen30.5136570.032772

Cheers

Andrew