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: 
Anonymous
Not applicable

Trying to convert data to USD with exchange rates

I am in the process of trying to convert my data with USD Average Rate.

Currently I have 3 tables that connect. These are what each excel sheet contains

1. Entity Code and Amount

2. Exchange rate and Entity Code

3. Date and Exchange rate.

I am not sure what function to use, but I want to convert the amount into USD through the data load editor. Currently right now my data shows the amounts in function currency. Those currencies range from variance currencies. I need to convert the numbers on excel sheet 1 to USD. I would like some feedback on how to convert the amounts.

Thanks!

Julia

4 Replies
ychaitanya
Creator III
Creator III

Hi Julia

Please upload an excel sheet or sample data to provide the solution.

Thanks

CY

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Assuming the amounts in sheet1 are not sensitive to Date, try something like this:

ExchangeMap:

MAPPING LOAD EntityCode, ExchangeRate

FROM ....(sheet is sheet2$);     // Load map from Sheet2

Sheet1:

LOAD

     EntityCode,

     Amount,

      ApplyMap('ExchangeMap', EntityCode, 1) * Amount as AmountLC

FROM ....(sheet is sheet1$);

-Rob

Anonymous
Not applicable
Author

I have uploaded sample files. I need to convert the amount in 'amount' file from CAD to USD. This is just an example, but in my master file there are multiple currency codes I need to convert.

Anonymous
Not applicable
Author

The sheet is date sensitive. I have uploaded sample files for reference.