Transactions in different currencies

[#1]

I have a number of transactions that I have converted to a single currency. My issue is that I must create charts where the user can select the display currency and all values will be displayed in the users desired currency.

Can anyone point me to the best way to do this. I have a currency conversion table also.

I am a Qlikview novice

Thanks in advance

Paul

[#2]

You can use an expression that looks something like this:

=Currency&' '&[Default Value]*CurrencyRate

where Currency = '€' or '$' or ...

where [Default Value] = the value in the default currency

where CurrencyRate = rate bewteen the default currency and the selected currency

The Currency and CurrencyRate fields will most likely be in your conversion table.