Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have an exchange rate table.
However, some of the records are missing and i have to calculate the missing records.
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?
Go to Solution.
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
how can you calculate the exchange rate ?
you should rather gather the exchanges rates and insert the values on your tables.. no ?
The exchange rate is provided in the excel file.
Some exchange rate are missing which i need to use other record to calculate.
the exchange rate from PHP to USD = the rate (PHP to AUD) * the rate (AUD to USD).
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
You give me a great help.