topic Calculate diffrence in value to previous entry in App Development https://community.qlik.com/t5/App-Development/Calculate-diffrence-in-value-to-previous-entry/m-p/1991126#M81990 <P>Hi , I need to calculate the Sequence difference to the previous entry for every unique ID</P> <P>The result is the I am looking for is the added difference coloum</P> <TABLE width="420"> <TBODY> <TR> <TD width="64">Date</TD> <TD width="64">Time</TD> <TD width="100">Sequence</TD> <TD width="64">ID</TD> <TD width="64">&nbsp;</TD> <TD width="64">Difference</TD> </TR> <TR> <TD>2022/10/01</TD> <TD>07:09</TD> <TD>166</TD> <TD>24298574917860142</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>2022/10/01</TD> <TD>07:28</TD> <TD>167</TD> <TD>24298574917860142</TD> <TD>&nbsp;</TD> <TD>1</TD> </TR> <TR> <TD>2022/10/04</TD> <TD>06:47</TD> <TD>168</TD> <TD>24298574917860142</TD> <TD>&nbsp;</TD> <TD>1</TD> </TR> <TR> <TD>2022/10/04</TD> <TD>07:10</TD> <TD>169</TD> <TD>24298574917860142</TD> <TD>&nbsp;</TD> <TD>1</TD> </TR> <TR> <TD>2022/10/05</TD> <TD>06:49</TD> <TD>172</TD> <TD>24298574917860142</TD> <TD>&nbsp;</TD> <TD>3</TD> </TR> <TR> <TD>2022/10/05</TD> <TD>07:13</TD> <TD>173</TD> <TD>24298574917860142</TD> <TD>&nbsp;</TD> <TD>1</TD> </TR> <TR> <TD>2022/10/06</TD> <TD>06:49</TD> <TD>176</TD> <TD>24298574917860142</TD> <TD>&nbsp;</TD> <TD>3</TD> </TR> <TR> <TD>2022/10/06</TD> <TD>07:11</TD> <TD>177</TD> <TD>24298574917860142</TD> <TD>&nbsp;</TD> <TD>1</TD> </TR> <TR> <TD>2022/10/08</TD> <TD>07:18</TD> <TD>180</TD> <TD>24298574917860142</TD> <TD>&nbsp;</TD> <TD>3</TD> </TR> <TR> <TD>2022/10/08</TD> <TD>07:39</TD> <TD>181</TD> <TD>24298574917860142</TD> <TD>&nbsp;</TD> <TD>1</TD> </TR> <TR> <TD>2022/10/10</TD> <TD>06:49</TD> <TD>182</TD> <TD>24298574917860142</TD> <TD>&nbsp;</TD> <TD>1</TD> </TR> <TR> <TD>2022/10/10</TD> <TD>07:10</TD> <TD>183</TD> <TD>24298574917860142</TD> <TD>&nbsp;</TD> <TD>1</TD> </TR> <TR> <TD>2022/10/10</TD> <TD>07:14</TD> <TD>184</TD> <TD>24298574917860142</TD> <TD>&nbsp;</TD> <TD>1</TD> </TR> </TBODY> </TABLE> Tue, 11 Oct 2022 07:23:30 GMT Ironzem 2022-10-11T07:23:30Z Calculate diffrence in value to previous entry https://community.qlik.com/t5/App-Development/Calculate-diffrence-in-value-to-previous-entry/m-p/1991126#M81990 <P>Hi , I need to calculate the Sequence difference to the previous entry for every unique ID</P> <P>The result is the I am looking for is the added difference coloum</P> <TABLE width="420"> <TBODY> <TR> <TD width="64">Date</TD> <TD width="64">Time</TD> <TD width="100">Sequence</TD> <TD width="64">ID</TD> <TD width="64">&nbsp;</TD> <TD width="64">Difference</TD> </TR> <TR> <TD>2022/10/01</TD> <TD>07:09</TD> <TD>166</TD> <TD>24298574917860142</TD> <TD>&nbsp;</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>2022/10/01</TD> <TD>07:28</TD> <TD>167</TD> <TD>24298574917860142</TD> <TD>&nbsp;</TD> <TD>1</TD> </TR> <TR> <TD>2022/10/04</TD> <TD>06:47</TD> <TD>168</TD> <TD>24298574917860142</TD> <TD>&nbsp;</TD> <TD>1</TD> </TR> <TR> <TD>2022/10/04</TD> <TD>07:10</TD> <TD>169</TD> <TD>24298574917860142</TD> <TD>&nbsp;</TD> <TD>1</TD> </TR> <TR> <TD>2022/10/05</TD> <TD>06:49</TD> <TD>172</TD> <TD>24298574917860142</TD> <TD>&nbsp;</TD> <TD>3</TD> </TR> <TR> <TD>2022/10/05</TD> <TD>07:13</TD> <TD>173</TD> <TD>24298574917860142</TD> <TD>&nbsp;</TD> <TD>1</TD> </TR> <TR> <TD>2022/10/06</TD> <TD>06:49</TD> <TD>176</TD> <TD>24298574917860142</TD> <TD>&nbsp;</TD> <TD>3</TD> </TR> <TR> <TD>2022/10/06</TD> <TD>07:11</TD> <TD>177</TD> <TD>24298574917860142</TD> <TD>&nbsp;</TD> <TD>1</TD> </TR> <TR> <TD>2022/10/08</TD> <TD>07:18</TD> <TD>180</TD> <TD>24298574917860142</TD> <TD>&nbsp;</TD> <TD>3</TD> </TR> <TR> <TD>2022/10/08</TD> <TD>07:39</TD> <TD>181</TD> <TD>24298574917860142</TD> <TD>&nbsp;</TD> <TD>1</TD> </TR> <TR> <TD>2022/10/10</TD> <TD>06:49</TD> <TD>182</TD> <TD>24298574917860142</TD> <TD>&nbsp;</TD> <TD>1</TD> </TR> <TR> <TD>2022/10/10</TD> <TD>07:10</TD> <TD>183</TD> <TD>24298574917860142</TD> <TD>&nbsp;</TD> <TD>1</TD> </TR> <TR> <TD>2022/10/10</TD> <TD>07:14</TD> <TD>184</TD> <TD>24298574917860142</TD> <TD>&nbsp;</TD> <TD>1</TD> </TR> </TBODY> </TABLE> Tue, 11 Oct 2022 07:23:30 GMT https://community.qlik.com/t5/App-Development/Calculate-diffrence-in-value-to-previous-entry/m-p/1991126#M81990 Ironzem 2022-10-11T07:23:30Z Re: Calculate diffrence in value to previous entry https://community.qlik.com/t5/App-Development/Calculate-diffrence-in-value-to-previous-entry/m-p/1991149#M81994 <P><STRONG>in load script</STRONG></P> <LI-CODE lang="markup">Temp: Load Date ,Time ,Sequence ,ID From SomeSource.qvd; Main: Load * ,ID-peek(ID) as Difference Resident Temp Order by Date,Time,ID ASC; Drop table Temp;</LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> <P><STRONG>IF In Chart then</STRONG></P> <P><STRONG>=ID - Above(ID)</STRONG></P> Tue, 11 Oct 2022 08:10:28 GMT https://community.qlik.com/t5/App-Development/Calculate-diffrence-in-value-to-previous-entry/m-p/1991149#M81994 vinieme12 2022-10-11T08:10:28Z Re: Calculate diffrence in value to previous entry https://community.qlik.com/t5/App-Development/Calculate-diffrence-in-value-to-previous-entry/m-p/1991443#M82014 <P>Thank you - I think there was a typo , ID---&gt;Sequence</P> Tue, 11 Oct 2022 16:56:20 GMT https://community.qlik.com/t5/App-Development/Calculate-diffrence-in-value-to-previous-entry/m-p/1991443#M82014 Ironzem 2022-10-11T16:56:20Z