topic Counting previous row and totals in QlikView https://community.qlik.com/t5/QlikView/Counting-previous-row-and-totals/m-p/560932#M209361 <HTML><HEAD></HEAD><BODY><P>Hi i have a situation whereby i would like to accumulate in my column and present the total in the totals row. </P><P></P><P>I have 3 expressions</P><P>1. Order</P><P>2. Stock </P><P>3. Purchase Orders</P><P>4. Available Stock is calculated as follows (Stock - Order + Purchase Orders)</P><P></P><P>Stock is always at the level that you see now so for example 50 for Art No. 100.</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Art No. </STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Date<BR /></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Stock (right now)</STRONG></TH><TD>Order</TD><TD>Purchase Order</TD><TD>Available Stock</TD></TR><TR><TD style="padding: 2px;">100</TD><TD style="padding: 2px;">2013-10-20</TD><TD style="padding: 2px;">50</TD><TD style="padding: 2px;">200</TD><TD style="padding: 2px;">0</TD><TD style="padding: 2px;">-150</TD></TR><TR><TD style="padding: 2px;">100</TD><TD style="padding: 2px;">2012-11-20</TD><TD style="padding: 2px;">50</TD><TD style="padding: 2px;">300</TD><TD style="padding: 2px;">200</TD><TD style="padding: 2px;">-250</TD></TR><TR><TD style="padding: 2px;">Total Art No</TD><TD style="padding: 2px;">-</TD><TD style="padding: 2px;">50</TD><TD style="padding: 2px;">500</TD><TD style="padding: 2px;">200</TD><TD style="padding: 2px;">-250</TD></TR><TR><TD style="padding: 2px;">200</TD><TD style="padding: 2px;">2013-09-15</TD><TD style="padding: 2px;">30</TD><TD style="padding: 2px;">25</TD><TD style="padding: 2px;">10</TD><TD style="padding: 2px;">15</TD></TR><TR><TD style="padding: 2px;">200</TD><TD style="padding: 2px;">2013-10-20</TD><TD style="padding: 2px;">30</TD><TD style="padding: 2px;">10</TD><TD style="padding: 2px;">0</TD><TD style="padding: 2px;">5</TD></TR><TR><TD style="padding: 2px;">Total Art No</TD><TD style="padding: 2px;">-</TD><TD style="padding: 2px;">30</TD><TD style="padding: 2px;">35</TD><TD style="padding: 2px;">10</TD><TD style="padding: 2px;">5</TD></TR></TBODY></TABLE><P></P><P></P><P>Best Brad</P></BODY></HTML> Tue, 24 Sep 2013 13:59:27 GMT 2013-09-24T13:59:27Z Counting previous row and totals https://community.qlik.com/t5/QlikView/Counting-previous-row-and-totals/m-p/560932#M209361 <HTML><HEAD></HEAD><BODY><P>Hi i have a situation whereby i would like to accumulate in my column and present the total in the totals row. </P><P></P><P>I have 3 expressions</P><P>1. Order</P><P>2. Stock </P><P>3. Purchase Orders</P><P>4. Available Stock is calculated as follows (Stock - Order + Purchase Orders)</P><P></P><P>Stock is always at the level that you see now so for example 50 for Art No. 100.</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Art No. </STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Date<BR /></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Stock (right now)</STRONG></TH><TD>Order</TD><TD>Purchase Order</TD><TD>Available Stock</TD></TR><TR><TD style="padding: 2px;">100</TD><TD style="padding: 2px;">2013-10-20</TD><TD style="padding: 2px;">50</TD><TD style="padding: 2px;">200</TD><TD style="padding: 2px;">0</TD><TD style="padding: 2px;">-150</TD></TR><TR><TD style="padding: 2px;">100</TD><TD style="padding: 2px;">2012-11-20</TD><TD style="padding: 2px;">50</TD><TD style="padding: 2px;">300</TD><TD style="padding: 2px;">200</TD><TD style="padding: 2px;">-250</TD></TR><TR><TD style="padding: 2px;">Total Art No</TD><TD style="padding: 2px;">-</TD><TD style="padding: 2px;">50</TD><TD style="padding: 2px;">500</TD><TD style="padding: 2px;">200</TD><TD style="padding: 2px;">-250</TD></TR><TR><TD style="padding: 2px;">200</TD><TD style="padding: 2px;">2013-09-15</TD><TD style="padding: 2px;">30</TD><TD style="padding: 2px;">25</TD><TD style="padding: 2px;">10</TD><TD style="padding: 2px;">15</TD></TR><TR><TD style="padding: 2px;">200</TD><TD style="padding: 2px;">2013-10-20</TD><TD style="padding: 2px;">30</TD><TD style="padding: 2px;">10</TD><TD style="padding: 2px;">0</TD><TD style="padding: 2px;">5</TD></TR><TR><TD style="padding: 2px;">Total Art No</TD><TD style="padding: 2px;">-</TD><TD style="padding: 2px;">30</TD><TD style="padding: 2px;">35</TD><TD style="padding: 2px;">10</TD><TD style="padding: 2px;">5</TD></TR></TBODY></TABLE><P></P><P></P><P>Best Brad</P></BODY></HTML> Tue, 24 Sep 2013 13:59:27 GMT https://community.qlik.com/t5/QlikView/Counting-previous-row-and-totals/m-p/560932#M209361 2013-09-24T13:59:27Z