Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.