topic Re: xRates Calculation in QlikView

xRates Calculation

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I need to calculate the difference for Sales, Year= 2015, using the xrate for that period and the Sales for the same period using the xrate for 2016.

Any ideas, how to?

Thanks.

Re: xRates Calculation

Anil_Babu_Samineni — Fri, 31 Mar 2017 16:41:56 GMT

Can you explain bit more, Please? I am assuming, you may need this?

Sum({<Year = {'2015'}, period = {'xrate'}>}Sales)

Sum({<Year = {'2016'}, period = {'xrate'}>}Sales)

Re: xRates Calculation

devarasu07 — Fri, 31 Mar 2017 17:47:27 GMT

Hi,

xRates Cal.? you mean exchange rate calculate for two different year?

If Yes, try like bloew John solution.

Currency Conversion

Thanks,

Deva

Re: xRates Calculation

Sat, 01 Apr 2017 09:10:07 GMT

Hi all,

Let me elaborate a bit more:

This is to be applied in a table with Last Year Sales as first column and YTD Sales in the last.

The idea is to have also the calculation for (Last Year Sales/ Exchange Rate for Last Year) - (Last Year Sales/ Exchange Rate YTD ) included on this table.

I also use a standard currency conversion script to have all exchange rates.

Thanks for the replies.