topic Re: How to handle Currencies? in QlikView

How to handle Currencies?

Tue, 26 Apr 2016 08:21:22 GMT

Hey guys, Im working on a applikation please find attached file.

I have a Currencies.QVD which I reload everyday. In This QVD everything si mapped to EUR which is = 1. So in my expressions I use turnover*rate_eur to make everything in EUR.

But I want to made turnover in USD also for example. How would that be done im sorry but I have really read the forums and can't seem to get it to work unfortunately 😕

Re: How to handle Currencies?

luciancotea — Tue, 26 Apr 2016 09:40:40 GMT

Try to attach small examples, not the entire solution.

The standard way to hava a multi-currency application:

1. Create one 'SelectedCurrency' variable where you list all the currencies you want. You use an InputBox to allow selection.

Let's say you have EUR and USD as options. And your exchange rate table have rate_EUR and rate_USD.

Other way is to have an isolated table in the data model that contains the currencies. You use a listbox to allow selection.

2. Create a 'CurrencyField' variable with the definition: ='rate_' & $(SelectedCurrency)

3. In your charts, use: =turnover * $(CurrencyField)

Re: How to handle Currencies?

Tue, 26 Apr 2016 10:26:18 GMT

I have a isolated table with currencies in relative to EUR which is set to 1. That's what I wanted to describe above.

So in expressions I calculate turnover by divide it to rate_eur to get everything in euros.

Re: How to handle Currencies?

Tue, 26 Apr 2016 10:35:38 GMT

Re: How to handle Currencies?

luciancotea — Tue, 26 Apr 2016 12:37:21 GMT

All depends on the data model, not individual fields.

So, to use a listbox for currencies, you need a CurrencyExchangeRatesTable linked to your main transactions table by a YearMonth key (if you use monthly rates) or Date key (if you use daily rates)

The CurrencyExchangeRatesTable will have the following fields: YearMonth - Currency - Rate

Your main transactions table will have turnover expressed in EUR, therefore you will have the value '1' as exchange rate.

So, in the interface, use a ListBox (select 'Only one selected value') and you will use '=turnover * Rate' in your charts.

Re: How to handle Currencies?

Tue, 26 Apr 2016 12:50:11 GMT

I solved it by making a LOAD of the same currencytable but for one currency and one currency only in this case USD. then I go from Local Currency to EUR (that my db table is mapped to) and then from EUR to USD in the expression.

It might not be best practice but it works!

Re: How to handle Currencies?

luciancotea — Tue, 26 Apr 2016 13:08:18 GMT

Of course it works

There are a lot of ways to achieve that.