Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.


Pivot table Conversion Rates

The two values are exchange rates, the first is the current exchange rate at the time of sale. The second is the previous exchange rate for that country.

How do i get this value in a column in this Pivot table by customer?

     Current rate - previous rate and calculate it for every rows sale:

To show the increase or decrease in revenue minus the currency conversion difference if any.

Questions Is the revenue increase  or decrease due to better or worst conversion rates?

Community Browser