topic Cummulative in QlikView https://community.qlik.com/t5/QlikView/Cummulative/m-p/303713#M1180498 <HTML><HEAD></HEAD><BODY><P>No. I need that in table.</P></BODY></HTML> Tue, 21 Feb 2012 12:03:15 GMT 2012-02-21T12:03:15Z Cummulative https://community.qlik.com/t5/QlikView/Cummulative/m-p/303711#M1180496 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I need help on cummulative.</P><P></P><P>Eg.</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="156" style="border-image: initial; width: 136px; height: 158px; border-width: 1px; border-color: #000000; border-style: solid;" width="146"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Amount<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Cummulative Amount<BR /></STRONG></SPAN></TH></TR><TR><TD>1</TD><TD>1</TD></TR><TR><TD>2</TD><TD>3</TD></TR><TR><TD>3</TD><TD>6</TD></TR><TR><TD>4</TD><TD>10</TD></TR><TR><TD>5</TD><TD>15</TD></TR></TBODY></TABLE><P></P><P>Can anybody please tell the syntax to calculate 'Cummulative Amount'..</P></BODY></HTML> Tue, 21 Feb 2012 11:53:50 GMT https://community.qlik.com/t5/QlikView/Cummulative/m-p/303711#M1180496 2012-02-21T11:53:50Z Cummulative https://community.qlik.com/t5/QlikView/Cummulative/m-p/303712#M1180497 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>If you need that in chart you can use acummulation settings in chart preferences (Expressions tab).</P><P></P><P>Przemek</P></BODY></HTML> Tue, 21 Feb 2012 11:56:22 GMT https://community.qlik.com/t5/QlikView/Cummulative/m-p/303712#M1180497 2012-02-21T11:56:22Z Cummulative https://community.qlik.com/t5/QlikView/Cummulative/m-p/303713#M1180498 <HTML><HEAD></HEAD><BODY><P>No. I need that in table.</P></BODY></HTML> Tue, 21 Feb 2012 12:03:15 GMT https://community.qlik.com/t5/QlikView/Cummulative/m-p/303713#M1180498 2012-02-21T12:03:15Z Cummulative https://community.qlik.com/t5/QlikView/Cummulative/m-p/303714#M1180499 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>If you are using Straight table try using the Full Accumulation in Expression tab.</P><P></P><P>Regards,</P><P>jagan.</P></BODY></HTML> Tue, 21 Feb 2012 12:05:44 GMT https://community.qlik.com/t5/QlikView/Cummulative/m-p/303714#M1180499 jagan 2012-02-21T12:05:44Z Re: Cummulative https://community.qlik.com/t5/QlikView/Cummulative/m-p/303715#M1180500 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Hope the attached sample helps you.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Tue, 21 Feb 2012 12:06:54 GMT https://community.qlik.com/t5/QlikView/Cummulative/m-p/303715#M1180500 jagan 2012-02-21T12:06:54Z Re: Cummulative https://community.qlik.com/t5/QlikView/Cummulative/m-p/303716#M1180501 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Try with this expression.</P><P>&nbsp;&nbsp;&nbsp;&nbsp; =Sum(Amount) + Alt(Above([Cummulative Amount]),0)</P><P></P><P>Celambarasan</P></BODY></HTML> Tue, 21 Feb 2012 13:19:33 GMT https://community.qlik.com/t5/QlikView/Cummulative/m-p/303716#M1180501 CELAMBARASAN 2012-02-21T13:19:33Z Re: Cummulative https://community.qlik.com/t5/QlikView/Cummulative/m-p/303717#M1180502 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">This is the expression that I use in my Chart. I have Set analysis filtering a Cost type to Obligated, so its possible.</SPAN></P><P></P><P><SPAN style="font-size: 10pt;"><SPAN style="font-family: 'Courier New'; color: black;">=</SPAN><SPAN style="font-family: 'Courier New'; color: blue;">RangeSum</SPAN><SPAN style="font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-family: 'Courier New'; color: blue;">above</SPAN><SPAN style="font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-family: 'Courier New'; color: blue;">Sum</SPAN><SPAN style="font-family: 'Courier New'; color: black;">({$&lt;</SPAN><SPAN style="font-family: 'Courier New'; color: maroon;">[Cost Type]</SPAN><SPAN style="font-family: 'Courier New'; color: black;">={</SPAN><SPAN style="font-family: 'Courier New'; color: maroon;">"Obligated*"</SPAN><SPAN style="font-family: 'Courier New'; color: black;">}&gt;}</SPAN><SPAN style="font-family: 'Courier New'; color: maroon;">Amount</SPAN><SPAN style="font-family: 'Courier New'; color: black;">),0, </SPAN><SPAN style="font-family: 'Courier New'; color: blue;">rowno</SPAN><SPAN style="font-family: 'Courier New'; color: black;">()))</SPAN></SPAN></P><P><SPAN style="font-family: 'Courier New'; color: black; font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">No set analysis:</SPAN></P><P><SPAN style="font-size: 10pt;"><SPAN style="font-family: 'Courier New'; color: blue;">RangeSum</SPAN><SPAN style="font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-family: 'Courier New'; color: blue;">above</SPAN><SPAN style="font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-family: 'Courier New'; color: blue;">Sum</SPAN><SPAN style="font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-family: 'Courier New'; color: maroon;">Amount</SPAN><SPAN style="font-family: 'Courier New'; color: black;">),0, </SPAN><SPAN style="font-family: 'Courier New'; color: blue;">rowno</SPAN></SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"><SPAN style="font-size: 10pt;">())) </SPAN><BR /></SPAN></P></BODY></HTML> Tue, 25 Sep 2012 14:52:34 GMT https://community.qlik.com/t5/QlikView/Cummulative/m-p/303717#M1180502 2012-09-25T14:52:34Z