https://community.qlik.com/t5/App-Development/Calculating-difference-using-previous-values/m-p/1585258#M42805 <P>Hello,</P><P>This is my Data from excel</P><P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline"><SPAN class="lia-message-image-wrapper lia-message-image-actions-narrow lia-message-image-actions-below"><IMG src="https://community.qlik.com/t5/image/serverpage/image-id/12688i3E663A6DC0D83A60/image-size/large?v=1.0&amp;px=999" border="0" alt="HRV excel.png" title="HRV excel.png" /></SPAN><SPAN class="lia-inline-image-caption">Excel file</SPAN></SPAN></P><P>this is the data load editor&nbsp;</P><P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline"><SPAN class="lia-message-image-wrapper lia-message-image-actions-narrow lia-message-image-actions-below"><IMG src="https://community.qlik.com/t5/image/serverpage/image-id/12690iDA2E3767A889AAE7/image-size/large?v=1.0&amp;px=999" border="0" alt="hrv1.png" title="hrv1.png" /></SPAN><SPAN class="lia-inline-image-caption">Data load editor</SPAN></SPAN></P><P>So far i have been able to calculate the standard deviation and average for the values in the chart expressions.</P><P>How do i calculate the successive differences, that is the differences between each value for each date. For example, 31/07/2017 will be 929-1079 and so on. i want to&nbsp; display the results in a table .</P> Mon, 27 May 2019 21:20:11 GMT stxphxe 2019-05-27T21:20:11Z https://community.qlik.com/t5/App-Development/Calculating-difference-using-previous-values/m-p/1585258#M42805 <P>Hello,</P><P>This is my Data from excel</P><P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline"><SPAN class="lia-message-image-wrapper lia-message-image-actions-narrow lia-message-image-actions-below"><IMG src="https://community.qlik.com/t5/image/serverpage/image-id/12688i3E663A6DC0D83A60/image-size/large?v=1.0&amp;px=999" border="0" alt="HRV excel.png" title="HRV excel.png" /></SPAN><SPAN class="lia-inline-image-caption">Excel file</SPAN></SPAN></P><P>this is the data load editor&nbsp;</P><P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline"><SPAN class="lia-message-image-wrapper lia-message-image-actions-narrow lia-message-image-actions-below"><IMG src="https://community.qlik.com/t5/image/serverpage/image-id/12690iDA2E3767A889AAE7/image-size/large?v=1.0&amp;px=999" border="0" alt="hrv1.png" title="hrv1.png" /></SPAN><SPAN class="lia-inline-image-caption">Data load editor</SPAN></SPAN></P><P>So far i have been able to calculate the standard deviation and average for the values in the chart expressions.</P><P>How do i calculate the successive differences, that is the differences between each value for each date. For example, 31/07/2017 will be 929-1079 and so on. i want to&nbsp; display the results in a table .</P> Mon, 27 May 2019 21:20:11 GMT https://community.qlik.com/t5/App-Development/Calculating-difference-using-previous-values/m-p/1585258#M42805 stxphxe 2019-05-27T21:20:11Z