topic Re: Cummulative Sum If with condition in QlikView https://community.qlik.com/t5/QlikView/Cummulative-Sum-If-with-condition/m-p/591958#M1102852 <HTML><HEAD></HEAD><BODY><P>Dear Massimo,</P><P>Thanks for quick reply, Issue is resolved. </P><P>You were correct the in 3'rd Row of <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; text-align: center;">AvailableStock</SPAN> the value should be 15.</P><P></P><P></P><P>Dear Patrick,</P><P>Thanks for further help.</P><P></P><P>Regards,</P><P>Girish.</P></BODY></HTML> Thu, 03 Apr 2014 05:48:15 GMT girish_talele 2014-04-03T05:48:15Z Cummulative Sum If with condition https://community.qlik.com/t5/QlikView/Cummulative-Sum-If-with-condition/m-p/591955#M1102848 <HTML><HEAD></HEAD><BODY><P>Dear Experts,</P><P>We have a Requirement &amp; Stock Table as given below,</P><P></P><P>ReqTable&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; StockTable</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 320px;"><TBODY><TR><TD class="xl65" height="20" style="text-align: center;" width="64">Material</TD><TD class="xl65" style="border-left-style: none; text-align: center;" width="64">Reqmt</TD><TD style="text-align: center;" width="64"></TD><TD class="xl65" style="text-align: center;" width="64">Material</TD><TD class="xl65" style="border-left-style: none; text-align: center;" width="64">Stock</TD></TR><TR><TD class="xl65" height="20" style="border-top-style: none; text-align: center;">1</TD><TD class="xl65" style="border-top-style: none; border-left-style: none; text-align: center;">10</TD><TD style="text-align: center;"></TD><TD class="xl65" style="border-top-style: none; text-align: center;">1</TD><TD class="xl65" style="border-top-style: none; border-left-style: none; text-align: center;">30</TD></TR><TR><TD class="xl65" height="20" style="border-top-style: none; text-align: center;">1</TD><TD class="xl65" style="border-top-style: none; border-left-style: none; text-align: center;">5</TD><TD style="text-align: center;"></TD><TD class="xl65" style="border-top-style: none; text-align: center;">2</TD><TD class="xl65" style="border-top-style: none; border-left-style: none; text-align: center;">10</TD></TR><TR><TD class="xl65" height="20" style="border-top-style: none; text-align: center;">1</TD><TD class="xl65" style="border-top-style: none; border-left-style: none; text-align: center;">20</TD><TD style="text-align: center;"></TD><TD class="xl65" style="border-top-style: none; text-align: center;">3</TD><TD class="xl65" style="border-top-style: none; border-left-style: none; text-align: center;">10</TD></TR><TR><TD class="xl65" height="20" style="border-top-style: none; text-align: center;">2</TD><TD class="xl65" style="border-top-style: none; border-left-style: none; text-align: center;">10</TD><TD style="text-align: center;"></TD><TD class="xl65" style="border-top-style: none; text-align: center;">4</TD><TD class="xl65" style="border-top-style: none; border-left-style: none; text-align: center;">0</TD></TR><TR><TD class="xl65" height="20" style="border-top-style: none; text-align: center;">2</TD><TD class="xl65" style="border-top-style: none; border-left-style: none; text-align: center;">4</TD><TD style="text-align: center;"></TD><TD class="xl65" style="border-top-style: none; text-align: center;">5</TD><TD class="xl65" style="border-top-style: none; border-left-style: none; text-align: center;">20</TD></TR><TR><TD class="xl65" height="20" style="border-top-style: none; text-align: center;">3</TD><TD class="xl65" style="border-top-style: none; border-left-style: none; text-align: center;">10</TD><TD style="text-align: center;"></TD><TD style="text-align: center;"></TD><TD style="text-align: center;"></TD></TR><TR><TD class="xl65" height="20" style="border-top-style: none; text-align: center;">4</TD><TD class="xl65" style="border-top-style: none; border-left-style: none; text-align: center;">10</TD><TD style="text-align: center;"></TD><TD style="text-align: center;"></TD><TD style="text-align: center;"></TD></TR><TR><TD class="xl65" height="20" style="border-top-style: none; text-align: center;">5</TD><TD class="xl65" style="border-top-style: none; border-left-style: none; text-align: center;">10</TD><TD style="text-align: center;"></TD><TD style="text-align: center;"></TD><TD style="text-align: center;"></TD></TR></TBODY></TABLE><P></P><P>We want to achieve results as given below-</P><P>Required Results :-</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 406px;"><TBODY><TR><TD class="xl74" height="21" style="text-align: center;" width="64">Material</TD><TD class="xl75" style="border-left-style: none; text-align: center;" width="64">Reqmt</TD><TD class="xl75" style="border-left-style: none; text-align: center;" width="179">Cummulative Requirement</TD><TD class="xl76" style="border-left-style: none; text-align: center;" width="99">AvailableStock</TD></TR><TR><TD class="xl66" height="20" style="border-top-style: none; text-align: center;">1</TD><TD class="xl67" style="border-top-style: none; border-left-style: none; text-align: center;">10</TD><TD class="xl67" style="border-top-style: none; border-left-style: none; text-align: center;">10</TD><TD class="xl68" style="border-top-style: none; border-left-style: none; text-align: center;">30</TD></TR><TR><TD class="xl69" height="20" style="border-top-style: none; text-align: center;">1</TD><TD class="xl65" style="border-top-style: none; border-left-style: none; text-align: center;">5</TD><TD class="xl65" style="border-top-style: none; border-left-style: none; text-align: center;">15</TD><TD class="xl70" style="border-top-style: none; border-left-style: none; text-align: center;">20</TD></TR><TR><TD class="xl71" height="21" style="border-top-style: none; text-align: center;">1</TD><TD class="xl72" style="border-top-style: none; border-left-style: none; text-align: center;">20</TD><TD class="xl72" style="border-top-style: none; border-left-style: none; text-align: center;">35</TD><TD class="xl73" style="border-top-style: none; border-left-style: none; text-align: center;">5</TD></TR><TR><TD class="xl66" height="20" style="border-top-style: none; text-align: center;">2</TD><TD class="xl67" style="border-top-style: none; border-left-style: none; text-align: center;">10</TD><TD class="xl67" style="border-top-style: none; border-left-style: none; text-align: center;">10</TD><TD class="xl68" style="border-top-style: none; border-left-style: none; text-align: center;">10</TD></TR><TR><TD class="xl71" height="21" style="border-top-style: none; text-align: center;">2</TD><TD class="xl72" style="border-top-style: none; border-left-style: none; text-align: center;">4</TD><TD class="xl72" style="border-top-style: none; border-left-style: none; text-align: center;">14</TD><TD class="xl73" style="border-top-style: none; border-left-style: none; text-align: center;">0</TD></TR><TR><TD class="xl66" height="20" style="border-top-style: none; text-align: center;">3</TD><TD class="xl67" style="border-top-style: none; border-left-style: none; text-align: center;">10</TD><TD class="xl67" style="border-top-style: none; border-left-style: none; text-align: center;">10</TD><TD class="xl68" style="border-top-style: none; border-left-style: none; text-align: center;">10</TD></TR><TR><TD class="xl69" height="20" style="border-top-style: none; text-align: center;">4</TD><TD class="xl65" style="border-top-style: none; border-left-style: none; text-align: center;">10</TD><TD class="xl65" style="border-top-style: none; border-left-style: none; text-align: center;">10</TD><TD class="xl70" style="border-top-style: none; border-left-style: none; text-align: center;">0</TD></TR><TR><TD class="xl71" height="21" style="border-top-style: none; text-align: center;">5</TD><TD class="xl72" style="border-top-style: none; border-left-style: none; text-align: center;">10</TD><TD class="xl72" style="border-top-style: none; border-left-style: none; text-align: center;">10</TD><TD class="xl73" style="border-top-style: none; border-left-style: none; text-align: center;">20</TD></TR></TBODY></TABLE><P></P><P>Tried hard but unable to find out the way.</P><P>Please help us with your expertise.</P><P></P><P>Thanks,</P><P>Girish.</P></BODY></HTML> Wed, 02 Apr 2014 15:03:41 GMT https://community.qlik.com/t5/QlikView/Cummulative-Sum-If-with-condition/m-p/591955#M1102848 girish_talele 2014-04-02T15:03:41Z Re: Cummulative Sum If with condition https://community.qlik.com/t5/QlikView/Cummulative-Sum-If-with-condition/m-p/591956#M1102850 <HTML><HEAD></HEAD><BODY><P>see attachment</P><P></P><P><IMG alt="1.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/56433_1.png" style="width: auto; height: auto;" /></P></BODY></HTML> Wed, 02 Apr 2014 16:09:20 GMT https://community.qlik.com/t5/QlikView/Cummulative-Sum-If-with-condition/m-p/591956#M1102850 maxgro 2014-04-02T16:09:20Z Re: Cummulative Sum If with condition https://community.qlik.com/t5/QlikView/Cummulative-Sum-If-with-condition/m-p/591957#M1102851 <HTML><HEAD></HEAD><BODY><P>Hi Girish,</P><P></P><P>Please see attached. I actually got some help from Massimo on this. <IMG __jive_id="56436" alt="Clipboard01.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/56436_Clipboard01.jpg" /></P><P></P><P>Cheers!</P></BODY></HTML> Wed, 02 Apr 2014 17:22:12 GMT https://community.qlik.com/t5/QlikView/Cummulative-Sum-If-with-condition/m-p/591957#M1102851 2014-04-02T17:22:12Z Re: Cummulative Sum If with condition https://community.qlik.com/t5/QlikView/Cummulative-Sum-If-with-condition/m-p/591958#M1102852 <HTML><HEAD></HEAD><BODY><P>Dear Massimo,</P><P>Thanks for quick reply, Issue is resolved. </P><P>You were correct the in 3'rd Row of <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; text-align: center;">AvailableStock</SPAN> the value should be 15.</P><P></P><P></P><P>Dear Patrick,</P><P>Thanks for further help.</P><P></P><P>Regards,</P><P>Girish.</P></BODY></HTML> Thu, 03 Apr 2014 05:48:15 GMT https://community.qlik.com/t5/QlikView/Cummulative-Sum-If-with-condition/m-p/591958#M1102852 girish_talele 2014-04-03T05:48:15Z