xRates Calculation - Qlik Community

Report Inappropriate Content · ‎2017-03-31

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.

Anil_Babu_Samineni · ‎2017-03-31

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)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

devarasu07 · ‎2017-03-31

Hi,

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

If Yes, try like bloew John solution.

Currency Conversion

Thanks,

Deva

Report Inappropriate Content · ‎2017-04-01

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.