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

Generate missing Exchange Rate

Hi all,

I have an exchange rate table.

However, some of the records are missing and i have to calculate the missing records.

For example:

I need to calculate the exchange rate from PHP to USD.

What i need to do is using the rate (PHP to AUD) * the rate (AUD to USD).

Is it possible to generate all cases like (MMK to USD) by scripting?

Capture.PNG

Best Regards,

Louis

1 Solution

Accepted Solutions
t_chetirbok
Creator III
Creator III

In the attachment you can find a script with the example.

1. by default you can have only 5 currencies. if you need to add more, just put it to the inline load

2. AUD should always have all 5 rates

View solution in original post

5 Replies
YoussefBelloum
Champion
Champion

Hi,

how can you calculate the exchange rate ?

you should rather gather the exchanges rates and insert the values on your tables.. no ?

Anonymous
Not applicable
Author

Hi youssef,

The exchange rate is provided in the excel file.

Some exchange rate are missing which i need to use other record to calculate.

For example:

the exchange rate from PHP to USD =  the rate (PHP to AUD) * the rate (AUD to USD).

Best Regards,

Louis

t_chetirbok
Creator III
Creator III

Hi Louis,

It's possible if you always need to have the exact number of rates for each currency.

I mean 5 rows for AUD, 5 rows for PHP

t_chetirbok
Creator III
Creator III

In the attachment you can find a script with the example.

1. by default you can have only 5 currencies. if you need to add more, just put it to the inline load

2. AUD should always have all 5 rates

Anonymous
Not applicable
Author

Thanks Tatsiana.

You give me a great help.