Info on using exchange Rates

[#1]

I have to add a module that will allow an application to display transactions in different exchange rates. There is a table with the an exchange rate for each month. Is there a demo app or resource that can be downloaded already that shows how to add this functionality.

Any help is appreciated.

Paul

ps. this is my first post. I am a new developer.

[disqr_rm]

.

[justinasp · Accepted solution]

Hi Paul,

try to join yearmonth data with exchange range, something like that:

temp:
load *inline
[
yearmonth, sales_usd
200901, 15000
200902, 14000
200903, 15500
200904, 14500
];
left join
load * inline
[
yearmonth, usd_to_eur
200901, '0,728'
200902, '0,729'
200903, '0,726'
200904, '0,727'
];
sales:
load yearmonth,
 usd_to_eur,
 sum(sales_usd) as sales_usd,
 sum(sales_usd*usd_to_eur) as sales_eur
resident temp
group by yearmonth,usd_to_eur;
drop table temp;

Good luck!

And try using "APIguide.qvw" that you could find somewhere like "C:\Program Files\QlikView\Documentation\"

Justinas

[#4]

There is a good currency App under Share Qlikviews by Stephen Redmond which is worth a look it is called

Currency Demo v.2

Filed under: web, currency, html, Oanda, Multi-Currency

Hope this is of help

Neil

[#5]

Hi Neil,

this application seems not to be available anymore. Could you post it?

regards