Currency Conversion - Multi Change

Tue, 07 Jan 2014 09:28:37 GMT

Hi All,

Happy New Year to the Community.

My challenge for the beginning of 2014 is my budget program. In 2014 I decided it was time to unify two data-sources (same structure) one with currencies in Euro the other one in GBP. The main currency of choice is Euro.

My challenge is to display the currencies in TRN (Transaction), Converted Euro and for added 'fun' Converted USD. I would like the end user to be able to view a chart in any one of the 3 scenario's noted by clicking on 'something'

I have successfully as separate fields have converted transactional amounts in converted Euro and converted USD within the load script.

I appreciate that there are probably a few ways of doing this - my 1st thought was bookmarks and set analysis, I also thought of variables but unsure of this route. Set Analysis (and possibly lack of experience) has given me challenges that I would prefer to avoid if I can.

CIC_NETINCOME,

ApplyMap('EuroRate', CIC_CURRENCYCODE, null()) as EuroRate,

ApplyMap('USDRate', CIC_CURRENCYCODE, null()) as USDRate,

Is the extract of code I have used and in any chart I use CIC_NETINCOME (Transactional), CIC_NETINCOME * EuroRate (Euro) or CIC_NETINCOME * USDRate (USD).

Any thoughts/wisdom would be appreciated - I am looking for an elegant approach

Many thanks

Rob

Re: Currency Conversion - Multi Change

Thu, 09 Jan 2014 08:53:55 GMT

Hi All,

I got this working using a variable vCurrency

=sum(if(CIC_COMPARABLE = 'Current' AND vCurrency ='Euro', CIC_EURNETINCOME

,if(CIC_COMPARABLE = 'Current' AND vCurrency ='USD', CIC_USDNETINCOME ,0)))

I can elaborate further if anyone finds this useful.

Thanks,

Rob

Re: Currency Conversion - Multi Change

Mon, 20 Jan 2014 06:17:21 GMT

Hi Robert,

Could you share the QVW. It would be helpful.

Thanks & Regards,

Keerthi

topic Re: Currency Conversion - Multi Change in QlikView

Currency Conversion - Multi Change

Re: Currency Conversion - Multi Change

Re: Currency Conversion - Multi Change