topic sum() ? in QlikView https://community.qlik.com/t5/QlikView/sum/m-p/338244#M124738 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>i have the following tables</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 50%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ID<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Orders<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Month<BR /></STRONG></SPAN></TH></TR><TR><TD>1</TD><TD>2</TD><TD>2011-01</TD></TR><TR><TD>1</TD><TD>5</TD><TD>2011-02</TD></TR><TR><TD>1</TD><TD>0</TD><TD>2011-03</TD></TR><TR><TD>1</TD><TD>1</TD><TD>2011-04</TD></TR><TR><TD>2</TD><TD>1</TD><TD>2011-01</TD></TR><TR><TD>2</TD><TD>2</TD><TD>2011-02</TD></TR><TR><TD>2</TD><TD>1</TD><TD>2011-03</TD></TR><TR><TD>2</TD><TD>0</TD><TD>2011-04</TD></TR></TBODY></TABLE><P></P><P>Now i want to add a column that keeps the aggregation of all orders up to the record's row. Like this:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 50%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ID<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Orders<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Month<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>OrderAggregates<BR /></STRONG></SPAN></TH></TR><TR><TD>1</TD><TD>2</TD><TD>2011-01</TD><TD>2</TD></TR><TR><TD>1</TD><TD>5</TD><TD>2011-02</TD><TD>7</TD></TR><TR><TD>1</TD><TD>0</TD><TD>2011-03</TD><TD>7</TD></TR><TR><TD>1</TD><TD>1</TD><TD>2011-04</TD><TD>8</TD></TR><TR><TD>2</TD><TD>1</TD><TD>2011-01</TD><TD>1</TD></TR><TR><TD>2</TD><TD>2</TD><TD>2011-02</TD><TD>3</TD></TR><TR><TD>2</TD><TD>1</TD><TD>2011-03</TD><TD>4</TD></TR><TR><TD>2</TD><TD>0</TD><TD>2011-04</TD><TD>4</TD></TR></TBODY></TABLE><P></P><P>How can i do this ?</P><P></P><P>Thanks a lot!</P></BODY></HTML> Tue, 05 Jun 2012 14:06:19 GMT 2012-06-05T14:06:19Z sum() ? https://community.qlik.com/t5/QlikView/sum/m-p/338244#M124738 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>i have the following tables</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 50%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ID<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Orders<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Month<BR /></STRONG></SPAN></TH></TR><TR><TD>1</TD><TD>2</TD><TD>2011-01</TD></TR><TR><TD>1</TD><TD>5</TD><TD>2011-02</TD></TR><TR><TD>1</TD><TD>0</TD><TD>2011-03</TD></TR><TR><TD>1</TD><TD>1</TD><TD>2011-04</TD></TR><TR><TD>2</TD><TD>1</TD><TD>2011-01</TD></TR><TR><TD>2</TD><TD>2</TD><TD>2011-02</TD></TR><TR><TD>2</TD><TD>1</TD><TD>2011-03</TD></TR><TR><TD>2</TD><TD>0</TD><TD>2011-04</TD></TR></TBODY></TABLE><P></P><P>Now i want to add a column that keeps the aggregation of all orders up to the record's row. Like this:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 50%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ID<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Orders<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Month<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>OrderAggregates<BR /></STRONG></SPAN></TH></TR><TR><TD>1</TD><TD>2</TD><TD>2011-01</TD><TD>2</TD></TR><TR><TD>1</TD><TD>5</TD><TD>2011-02</TD><TD>7</TD></TR><TR><TD>1</TD><TD>0</TD><TD>2011-03</TD><TD>7</TD></TR><TR><TD>1</TD><TD>1</TD><TD>2011-04</TD><TD>8</TD></TR><TR><TD>2</TD><TD>1</TD><TD>2011-01</TD><TD>1</TD></TR><TR><TD>2</TD><TD>2</TD><TD>2011-02</TD><TD>3</TD></TR><TR><TD>2</TD><TD>1</TD><TD>2011-03</TD><TD>4</TD></TR><TR><TD>2</TD><TD>0</TD><TD>2011-04</TD><TD>4</TD></TR></TBODY></TABLE><P></P><P>How can i do this ?</P><P></P><P>Thanks a lot!</P></BODY></HTML> Tue, 05 Jun 2012 14:06:19 GMT https://community.qlik.com/t5/QlikView/sum/m-p/338244#M124738 2012-06-05T14:06:19Z sum() ? https://community.qlik.com/t5/QlikView/sum/m-p/338245#M124739 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P>Load ID, Orders, Mont, numsum( Orders, peek( 'OrderAggregates' ) ) as OrderAggregates</P><P>resident "OriginalTable"; </P></BODY></HTML> Tue, 05 Jun 2012 14:16:53 GMT https://community.qlik.com/t5/QlikView/sum/m-p/338245#M124739 2012-06-05T14:16:53Z sum() ? https://community.qlik.com/t5/QlikView/sum/m-p/338246#M124740 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; In load script or in charts?</P><P></P><P>Celambarasan</P></BODY></HTML> Tue, 05 Jun 2012 14:17:38 GMT https://community.qlik.com/t5/QlikView/sum/m-p/338246#M124740 CELAMBARASAN 2012-06-05T14:17:38Z sum() ? https://community.qlik.com/t5/QlikView/sum/m-p/338247#M124741 <HTML><HEAD></HEAD><BODY><P>In LOAD</P></BODY></HTML> Tue, 05 Jun 2012 14:22:19 GMT https://community.qlik.com/t5/QlikView/sum/m-p/338247#M124741 2012-06-05T14:22:19Z sum() ? https://community.qlik.com/t5/QlikView/sum/m-p/338248#M124742 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Check with <A _jive_internal="true" class="jiveTT-hover-user jive-username-link" href="https://community.qlik.com/people/quique" id="jive-213827338552226086266" style="background-color: #f9f9f9; font-size: 12px; color: #007fc0; font-weight: bold; font-family: Arial; text-align: center;">Enrique Bernat</A> suggestion it will work.</P><P></P><P>Celambarasan</P></BODY></HTML> Tue, 05 Jun 2012 14:27:38 GMT https://community.qlik.com/t5/QlikView/sum/m-p/338248#M124742 CELAMBARASAN 2012-06-05T14:27:38Z