https://community.qlik.com/t5/App-Development/Subtracting-to-values/m-p/1584720#M42765 <P>It doesn't give me the correct answer <span class="lia-unicode-emoji" title=":slightly_frowning_face:">🙁</span></P> Sat, 25 May 2019 05:04:06 GMT shri 2019-05-25T05:04:06Z https://community.qlik.com/t5/App-Development/Subtracting-to-values/m-p/1584448#M42738 <P>How to subtract two consecutive rows in a single column <STRONG>or/</STRONG></P><P>how to subtract two rows based on the selection of the filter ?</P><P>If Filter pane is of : Materials&nbsp;</P><P>Material&nbsp; &nbsp; &nbsp;Qty&nbsp; &nbsp; &nbsp;Result should be&nbsp;</P><P>1234&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50-20= 30</P><P>1334&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20-10=10</P><P>1554&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10-50= -40</P><P>1234&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 24 May 2019 11:48:49 GMT https://community.qlik.com/t5/App-Development/Subtracting-to-values/m-p/1584448#M42738 shri 2019-05-24T11:48:49Z https://community.qlik.com/t5/App-Development/Subtracting-to-values/m-p/1584476#M42743 <P>Hi Shri,</P><P>Add the following measure:</P><LI-CODE lang="markup">Sum(QTY)- Below(Sum(QTY))</LI-CODE><P>Jordy</P><P>Climber&nbsp;</P> Fri, 24 May 2019 12:06:21 GMT https://community.qlik.com/t5/App-Development/Subtracting-to-values/m-p/1584476#M42743 JordyWegman 2019-05-24T12:06:21Z https://community.qlik.com/t5/App-Development/Subtracting-to-values/m-p/1584720#M42765 <P>It doesn't give me the correct answer <span class="lia-unicode-emoji" title=":slightly_frowning_face:">🙁</span></P> Sat, 25 May 2019 05:04:06 GMT https://community.qlik.com/t5/App-Development/Subtracting-to-values/m-p/1584720#M42765 shri 2019-05-25T05:04:06Z