Currency Conversions

[#1]

Hi All,

I have a dashboard with values in GBP. I want it to be displayed in EUR or USD across all the charts in the dashboard.

When i select USD it should display values in USD. Please help me with this.

Thanks in advance,

Keerthi

[#2]

Hi Keerthi,

Go through this link  http://community.qlik.com/message/93743#93743

  Regards,
Santhosh G

[#3]

Thanks Santhosh. I will go through it.

[danieloberbilli]

I keep it pretty simple:

SET vExchangeRateGBP2Dollar = 1.64;

SET vExchangeRateGBP2Euro = 1.20;

Data:

LOAD

value as [Value (GBP)],

value * vExchangeRateGBP2Dollar      as [Value (USD)],

value * vExchangeRateGBP2Euro        as [Value (Euro)]

resident ...;

On the dashboard objects I use the Fields [Value (...)] in conditional expressions with the help of buttons: e.g. button1: set variable to USD    and then in the expression condition  if(vCurrency='USD', [Value (USD)]...

Regards

Daniel

[#5]

Hi Keerth

Please check this link: http://community.qlik.com/message/93743#93743, specifically check the solution provided by John Witherspoon.

Hope This resolves your issues.

Best Regards

Dlamini