topic Using data from one time period to compute values in another time period. in QlikView https://community.qlik.com/t5/QlikView/Using-data-from-one-time-period-to-compute-values-in-another/m-p/1168002#M909240 <HTML><HEAD></HEAD><BODY><P>Question regarding comparison of two time periods. I have no idea on how to code this in Qlik. Any idea is welcome.</P><P>The user can freely select what is period 1 and period 2, example, Q1 15 and Q1 16 or Q1 16 and Q2 16 or June 16 and July 16</P><P>The analysis is in both constant dollars and local currency </P><P>The first period dollar amount must be recomputed using the exchange rate of the second period</P><P>Exchange rate of second period is Price in dollar / price in local currency</P><P>This exchange rate can cover one or more months, including months which are in the future (Orders)</P><P>The dollar price of the first period is recomputed using the Price local currency Period 1 * exchange rate of period 2</P><P>The dollar amount of period 1 is computed using units of period 1 * recomputed&nbsp; Dollar price period 1</P><P>This works when the local currency code is displayed however I need to present the straight table using different levels of aggregations and I need to show a total.</P><P>The problem is that the exchange rate is then computed using the sum of different currencies and this is wrong</P><P>I would need something that computes (or materialize) the individual values and then the aggregations (or the total) should sum these individual values instead of using an exchange rate.</P><P>I do not think I can compute these values in the loading script since the user may select any period for period 1 and period 2</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Using data from one time period to compute values in another time period. https://community.qlik.com/t5/QlikView/Using-data-from-one-time-period-to-compute-values-in-another/m-p/1168002#M909240 <HTML><HEAD></HEAD><BODY><P>Question regarding comparison of two time periods. I have no idea on how to code this in Qlik. Any idea is welcome.</P><P>The user can freely select what is period 1 and period 2, example, Q1 15 and Q1 16 or Q1 16 and Q2 16 or June 16 and July 16</P><P>The analysis is in both constant dollars and local currency </P><P>The first period dollar amount must be recomputed using the exchange rate of the second period</P><P>Exchange rate of second period is Price in dollar / price in local currency</P><P>This exchange rate can cover one or more months, including months which are in the future (Orders)</P><P>The dollar price of the first period is recomputed using the Price local currency Period 1 * exchange rate of period 2</P><P>The dollar amount of period 1 is computed using units of period 1 * recomputed&nbsp; Dollar price period 1</P><P>This works when the local currency code is displayed however I need to present the straight table using different levels of aggregations and I need to show a total.</P><P>The problem is that the exchange rate is then computed using the sum of different currencies and this is wrong</P><P>I would need something that computes (or materialize) the individual values and then the aggregations (or the total) should sum these individual values instead of using an exchange rate.</P><P>I do not think I can compute these values in the loading script since the user may select any period for period 1 and period 2</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Using-data-from-one-time-period-to-compute-values-in-another/m-p/1168002#M909240 2020-11-25T16:16:04Z Re: Using data from one time period to compute values in another time period. https://community.qlik.com/t5/QlikView/Using-data-from-one-time-period-to-compute-values-in-another/m-p/1168003#M909241 <HTML><HEAD></HEAD><BODY><P>Would you be able to provide some sample data with the expected result you are looking for...</P></BODY></HTML> Wed, 22 Jun 2016 00:43:12 GMT https://community.qlik.com/t5/QlikView/Using-data-from-one-time-period-to-compute-values-in-another/m-p/1168003#M909241 sunny_talwar 2016-06-22T00:43:12Z Re: Using data from one time period to compute values in another time period. https://community.qlik.com/t5/QlikView/Using-data-from-one-time-period-to-compute-values-in-another/m-p/1168004#M909242 <HTML><HEAD></HEAD><BODY><P>This question is closed, I did two things that solved the issue<BR />- Changed the total computation to be sum of rows</P><P>- Added the currency dimension to the aggr expressions</P></BODY></HTML> Wed, 22 Jun 2016 23:26:52 GMT https://community.qlik.com/t5/QlikView/Using-data-from-one-time-period-to-compute-values-in-another/m-p/1168004#M909242 2016-06-22T23:26:52Z