Qlik Community

Ask a Question

App Development

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

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
deerhunter
Creator
Creator

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?

0 Replies