topic Cross Currency Rate Calculation in QlikView

Cross Currency Rate Calculation

Sat, 19 Nov 2011 20:29:53 GMT

Dear All,

I have two datasources. One of them has invoice ID, region, date, amount and currency type fields. The other one has date, source currency type, target currency type and currency value fields. I have make a connection with concatanation of date and currency type between two table. You can see the file attached.

I can convert the all currency types into TRY(Turkish Lira) but I also need to convert all currency types into USD and EUR. I need to find the reverse conversion of 1 TL= x EUR and 1TL =xUSD then multiply it toTRY values.

Looking forward to having a solution.

Best Regards,

Cross Currency Rate Calculation

Sun, 20 Nov 2011 07:22:41 GMT

Dear Asim,

I guess you need to create one more currency table in order to achive what you want.

If you create another currency table which may consists of Date, CurrencyName and CurrencyValue and joins to the NTF table over Date column. by this way, you already have each corresponding days TRY value, from the new currency table you can get these days EUR and USD values and you can divide TRY value with these currencies.

Omer

P.S: merhaba, community'deki başka insanların da yorumlarını yazabilmeleri ve ne oldugunu anlamarı için ingilizce yazdım..

Re: Cross Currency Rate Calculation

Sun, 20 Nov 2011 12:56:50 GMT

Dear Ömer,

Thanks for your help. I solved the problem. Here is the file with solution.

Best Regards,

Asim Akin