topic accumulation in QlikView

topic accumulation in QlikView https://community.qlik.com/t5/QlikView/accumulation/m-p/520818#M194576 <HTML><HEAD></HEAD><BODY><P>Hi all </P><P>i have the following table  </P><TABLE border="0" cellspacing="0" frame="VOID" rules="NONE"><TBODY><TR><TD bgcolor="#F5F5F5" height="17" style="border: 1px solid #dcdcdc;" width="63"><P></P><P><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">Date</STRONG></P></TD><TD bgcolor="#F5F5F5" style="border: 1px solid #dcdcdc;" width="66"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">Properties</STRONG></TD><TD bgcolor="#F5F5F5" style="border: 1px solid #dcdcdc;" width="38"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">Value</STRONG></TD></TR><TR><TD bgcolor="#FFFFFF" height="17" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">11/12/12</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">A/c</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">30</SPAN></TD></TR><TR><TD bgcolor="#FFFFFF" height="17" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">11/12/12</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">Fridge</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">20</SPAN></TD></TR><TR><TD bgcolor="#FFFFFF" height="17" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">12/12/12</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">A/c</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">40</SPAN></TD></TR><TR><TD bgcolor="#FFFFFF" height="17" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">12/12/12</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">Fridge</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">30</SPAN></TD></TR><TR><TD bgcolor="#FFFFFF" height="17" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">12/12/12</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">TV</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">60</SPAN></TD></TR><TR><TD bgcolor="#FFFFFF" height="17" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">13/12/12</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">Fridge</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">70</SPAN></TD></TR><TR><TD bgcolor="#FFFFFF" height="17" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">13/12/12</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">LCD</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">40</SPAN></TD></TR><TR><TD height="17"><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR></TBODY></TABLE><P>But i want the output like this </P><TABLE border="0" cellspacing="0" frame="VOID" rules="NONE"><TBODY><TR><TD bgcolor="#F5F5F5" height="17" style="border: 1px solid #dcdcdc;" width="63"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">Date</STRONG></TD><TD bgcolor="#F5F5F5" style="border: 1px solid #dcdcdc;" width="66"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">Properties</STRONG></TD><TD bgcolor="#F5F5F5" style="border: 1px solid #dcdcdc;" width="38"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">Value</STRONG></TD><TD width="67">total</TD></TR><TR><TD bgcolor="#FFFFFF" height="17" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">11/12/12</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">A/c</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">30</SPAN></TD><TD>30</TD></TR><TR><TD bgcolor="#FFFFFF" height="17" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">11/12/12</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">Fridge</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">20</SPAN></TD><TD>20</TD></TR><TR><TD bgcolor="#FFFFFF" height="17" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">12/12/12</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">A/c</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">40</SPAN></TD><TD>70</TD></TR><TR><TD bgcolor="#FFFFFF" height="17" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">12/12/12</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">Fridge</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">30</SPAN></TD><TD>50</TD></TR><TR><TD bgcolor="#FFFFFF" height="17" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">12/12/12</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">TV</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">60</SPAN></TD><TD>60</TD></TR><TR><TD bgcolor="#FFFFFF" height="17" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">13/12/12</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">Fridge</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">70</SPAN></TD><TD>120</TD></TR><TR><TD bgcolor="#FFFFFF" height="17" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">13/12/12</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">LCD</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">40</SPAN></TD><TD>40</TD></TR></TBODY></TABLE></BODY></HTML> Fri, 28 Jun 2013 11:19:08 GMT nizamsha 2013-06-28T11:19:08Z accumulation https://community.qlik.com/t5/QlikView/accumulation/m-p/520818#M194576 <HTML><HEAD></HEAD><BODY><P>Hi all </P><P>i have the following table  </P><TABLE border="0" cellspacing="0" frame="VOID" rules="NONE"><TBODY><TR><TD bgcolor="#F5F5F5" height="17" style="border: 1px solid #dcdcdc;" width="63"><P></P><P><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">Date</STRONG></P></TD><TD bgcolor="#F5F5F5" style="border: 1px solid #dcdcdc;" width="66"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">Properties</STRONG></TD><TD bgcolor="#F5F5F5" style="border: 1px solid #dcdcdc;" width="38"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">Value</STRONG></TD></TR><TR><TD bgcolor="#FFFFFF" height="17" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">11/12/12</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">A/c</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">30</SPAN></TD></TR><TR><TD bgcolor="#FFFFFF" height="17" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">11/12/12</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">Fridge</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">20</SPAN></TD></TR><TR><TD bgcolor="#FFFFFF" height="17" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">12/12/12</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">A/c</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">40</SPAN></TD></TR><TR><TD bgcolor="#FFFFFF" height="17" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">12/12/12</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">Fridge</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">30</SPAN></TD></TR><TR><TD bgcolor="#FFFFFF" height="17" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">12/12/12</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">TV</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">60</SPAN></TD></TR><TR><TD bgcolor="#FFFFFF" height="17" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">13/12/12</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">Fridge</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">70</SPAN></TD></TR><TR><TD bgcolor="#FFFFFF" height="17" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">13/12/12</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">LCD</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">40</SPAN></TD></TR><TR><TD height="17"><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR></TBODY></TABLE><P>But i want the output like this </P><TABLE border="0" cellspacing="0" frame="VOID" rules="NONE"><TBODY><TR><TD bgcolor="#F5F5F5" height="17" style="border: 1px solid #dcdcdc;" width="63"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">Date</STRONG></TD><TD bgcolor="#F5F5F5" style="border: 1px solid #dcdcdc;" width="66"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">Properties</STRONG></TD><TD bgcolor="#F5F5F5" style="border: 1px solid #dcdcdc;" width="38"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">Value</STRONG></TD><TD width="67">total</TD></TR><TR><TD bgcolor="#FFFFFF" height="17" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">11/12/12</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">A/c</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">30</SPAN></TD><TD>30</TD></TR><TR><TD bgcolor="#FFFFFF" height="17" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">11/12/12</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">Fridge</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">20</SPAN></TD><TD>20</TD></TR><TR><TD bgcolor="#FFFFFF" height="17" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">12/12/12</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">A/c</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">40</SPAN></TD><TD>70</TD></TR><TR><TD bgcolor="#FFFFFF" height="17" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">12/12/12</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">Fridge</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">30</SPAN></TD><TD>50</TD></TR><TR><TD bgcolor="#FFFFFF" height="17" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">12/12/12</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">TV</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">60</SPAN></TD><TD>60</TD></TR><TR><TD bgcolor="#FFFFFF" height="17" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">13/12/12</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">Fridge</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">70</SPAN></TD><TD>120</TD></TR><TR><TD bgcolor="#FFFFFF" height="17" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">13/12/12</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">LCD</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">40</SPAN></TD><TD>40</TD></TR></TBODY></TABLE></BODY></HTML> Fri, 28 Jun 2013 11:19:08 GMT https://community.qlik.com/t5/QlikView/accumulation/m-p/520818#M194576 nizamsha 2013-06-28T11:19:08Z