topic Re: Acumulative Expresion in QlikView https://community.qlik.com/t5/QlikView/Acumulative-Expresion/m-p/434885#M559638 <HTML><HEAD></HEAD><BODY><P>Thank you very much Gysbert. It's not just a correct answer, the proposed link is very useful.</P></BODY></HTML> Wed, 08 May 2013 07:52:25 GMT 2013-05-08T07:52:25Z Acumulative Expresion https://community.qlik.com/t5/QlikView/Acumulative-Expresion/m-p/434883#M559636 <HTML><HEAD></HEAD><BODY><P style="background-color: #ffffff; color: #737373; font-family: Arial;">Hi,</P><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">I have this entry data</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="213"><TBODY><TR><TD class="xl70" height="21" width="49">Month</TD><TD class="xl68" style="border-left: none;" width="64">DataType</TD><TD class="xl68" style="border-left: none;" width="50">Value1</TD><TD class="xl69" style="border-left: none;" width="50">Value2</TD></TR><TR><TD class="xl74" height="21">01</TD><TD class="xl66" style="border-left: none;">R</TD><TD align="right" class="xl66" style="border-left: none;">10</TD><TD align="right" class="xl71" style="border-top: none; border-left: none;">1</TD></TR><TR><TD class="xl74" height="20">01</TD><TD class="xl65" style="border-top: none; border-left: none;">O</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">12</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">1</TD></TR><TR><TD class="xl75" height="21" style="border-top: none;">02</TD><TD class="xl65" style="border-top: none; border-left: none;">R</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">11</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">1</TD></TR><TR><TD class="xl76" height="21" style="border-top: none;">02</TD><TD class="xl67" style="border-top: none; border-left: none;">O</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">15</TD><TD align="right" class="xl73" style="border-top: none; border-left: none;">2</TD></TR></TBODY></TABLE><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">and I would like to obtain this result</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 276px;"><TBODY><TR><TD class="xl65" height="21" width="64">Month</TD><TD class="xl71" colspan="2" style="border-left-style: none; text-align: center;" width="106">02</TD><TD class="xl70" colspan="2" style="border-left-style: none; text-align: center;" width="106">01</TD></TR><TR><TD class="xl64" height="21">DataType</TD><TD class="xl71" style="border-top-style: none; border-left-style: none; text-align: center;">R</TD><TD class="xl70" style="border-top-style: none; border-left-style: none; text-align: center;">O</TD><TD class="xl70" style="border-top-style: none; border-left-style: none; text-align: center;">R</TD><TD class="xl70" style="border-top-style: none; border-left-style: none; text-align: center;">O</TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">Value1</TD><TD align="right" class="xl68">21</TD><TD align="right" class="xl69" style="border-left: none;">27</TD><TD align="right" class="xl69" style="border-left: none;">10</TD><TD align="right" class="xl69" style="border-left: none;">12</TD></TR><TR><TD class="xl63" height="21" style="border-top: none;">Value2</TD><TD align="right" class="xl67" style="border-top: none;">2</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">3</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">1</TD></TR></TBODY></TABLE><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">where the rows Value1 and Value2 are acumulative expresions</P><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">Value1 = sum(Value1) = Value1 of Month 01 + <SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">Value1 of Month 02</SPAN></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">Value2 = sum(Value2) <SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">= Value2 of Month 01 + </SPAN><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">Value2 of Month 02</SPAN></P><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">I have tried doing this using an expression like&nbsp; RangeSum(below(<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">sum(Value1)</SPAN>, 0, NoOfRows())), but there is a problem with the dimension DataType.</P><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">so actually the result obtained is this</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 276px;"><TBODY><TR><TD class="xl68" height="21" width="64">Month</TD><TD class="xl73" colspan="2" style="border-left-style: none; text-align: center;" width="106">02</TD><TD class="xl74" colspan="2" style="border-left-style: none; text-align: center;" width="106">01</TD></TR><TR><TD class="xl67" height="21">DataType</TD><TD class="xl73" style="border-top-style: none; border-left-style: none; text-align: center;">R</TD><TD class="xl74" style="border-top-style: none; border-left-style: none; text-align: center;">O</TD><TD class="xl74" style="border-top-style: none; border-left-style: none; text-align: center;">R</TD><TD class="xl74" style="border-top-style: none; border-left-style: none; text-align: center;">O</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Value1</TD><TD align="right" class="xl71">11</TD><TD align="right" class="xl72" style="border-left: none;">15</TD><TD align="right" class="xl72" style="border-left: none;">10</TD><TD align="right" class="xl72" style="border-left: none;">12</TD></TR><TR><TD class="xl66" height="21" style="border-top: none;">Value2</TD><TD align="right" class="xl70" style="border-top: none;">1</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">2</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl69" style="border-top: none; border-left: none;">1</TD></TR></TBODY></TABLE><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">Any suggestions?</P></BODY></HTML> Tue, 07 May 2013 14:18:53 GMT https://community.qlik.com/t5/QlikView/Acumulative-Expresion/m-p/434883#M559636 2013-05-07T14:18:53Z Re: Acumulative Expresion https://community.qlik.com/t5/QlikView/Acumulative-Expresion/m-p/434884#M559637 <HTML><HEAD></HEAD><BODY><P>See attached example. See <A _jive_internal="true" href="https://community.qlik.com/docs/DOC-4252">this document</A> for a bit of explanation about the AsOf table.</P></BODY></HTML> Tue, 07 May 2013 14:47:56 GMT https://community.qlik.com/t5/QlikView/Acumulative-Expresion/m-p/434884#M559637 Gysbert_Wassenaar 2013-05-07T14:47:56Z Re: Acumulative Expresion https://community.qlik.com/t5/QlikView/Acumulative-Expresion/m-p/434885#M559638 <HTML><HEAD></HEAD><BODY><P>Thank you very much Gysbert. It's not just a correct answer, the proposed link is very useful.</P></BODY></HTML> Wed, 08 May 2013 07:52:25 GMT https://community.qlik.com/t5/QlikView/Acumulative-Expresion/m-p/434885#M559638 2013-05-08T07:52:25Z