topic Info on using exchange Rates in QlikView

Info on using exchange Rates

Wed, 17 Feb 2010 15:12:10 GMT

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.

Info on using exchange Rates

disqr_rm — Wed, 17 Feb 2010 15:32:36 GMT

Info on using exchange Rates

justinasp — Wed, 17 Feb 2010 15:36:29 GMT

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

Info on using exchange Rates

Wed, 17 Feb 2010 15:44:21 GMT

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

Info on using exchange Rates

Thu, 21 Jul 2011 08:00:56 GMT

Hi Neil,

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

regards