topic Re: Currency Conversions in QlikView

Currency Conversions

Wed, 08 Jan 2014 11:00:43 GMT

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

Re: Currency Conversions

Wed, 08 Jan 2014 11:03:41 GMT

Hi Keerthi,

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

Regards,
Santhosh G

Re: Currency Conversions

Wed, 08 Jan 2014 11:08:09 GMT

Thanks Santhosh. I will go through it.

Re: Currency Conversions

danieloberbilli — Wed, 08 Jan 2014 11:28:00 GMT

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

Re: Currency Conversions

Tue, 13 Jan 2015 13:34:18 GMT

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