Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

tiklam_dynasys
Contributor

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
Valued Contributor

Re: Generate missing Exchange Rate

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

5 Replies
YoussefBelloum
Esteemed Contributor

Re: Generate missing Exchange Rate

Hi,

how can you calculate the exchange rate ?

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

tiklam_dynasys
Contributor

Re: Generate missing Exchange Rate

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
Valued Contributor

Re: Generate missing Exchange Rate

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
Valued Contributor

Re: Generate missing Exchange Rate

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

tiklam_dynasys
Contributor

Re: Generate missing Exchange Rate

Thanks Tatsiana.

You give me a great help.

Community Browser