topic Re: RangeSum and Above in QlikView https://community.qlik.com/t5/QlikView/RangeSum-and-Above/m-p/571536#M212944 <HTML><HEAD></HEAD><BODY><P>See attached qvw.</P></BODY></HTML> Thu, 13 Mar 2014 16:47:29 GMT Gysbert_Wassenaar 2014-03-13T16:47:29Z RangeSum and Above https://community.qlik.com/t5/QlikView/RangeSum-and-Above/m-p/571533#M212941 <HTML><HEAD></HEAD><BODY><P>I have below table....</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="227"><TBODY><TR><TD class="xl70" height="21" width="83">PartNumber</TD><TD class="xl71" style="border-left: none;" width="79">Initial Stock</TD><TD class="xl71" style="border-left: none;" width="65">OrderQty</TD></TR><TR><TD class="xl68" height="20">A</TD><TD class="xl69" style="border-left: none;">200</TD><TD class="xl69" style="border-left: none;">100</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">A</TD><TD class="xl64" style="border-top: none; border-left: none;">200</TD><TD class="xl64" style="border-top: none; border-left: none;">20</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">A</TD><TD class="xl64" style="border-top: none; border-left: none;">200</TD><TD class="xl64" style="border-top: none; border-left: none;">50</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">A</TD><TD class="xl64" style="border-top: none; border-left: none;">200</TD><TD class="xl64" style="border-top: none; border-left: none;">20</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">B</TD><TD class="xl64" style="border-top: none; border-left: none;">300</TD><TD class="xl64" style="border-top: none; border-left: none;">100</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">B</TD><TD class="xl64" style="border-top: none; border-left: none;">300</TD><TD class="xl64" style="border-top: none; border-left: none;">80</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">B</TD><TD class="xl64" style="border-top: none; border-left: none;">300</TD><TD class="xl64" style="border-top: none; border-left: none;">20</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">B</TD><TD class="xl64" style="border-top: none; border-left: none;">300</TD><TD class="xl64" style="border-top: none; border-left: none;">40</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">B</TD><TD class="xl64" style="border-top: none; border-left: none;">300</TD><TD class="xl64" style="border-top: none; border-left: none;">60</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">C</TD><TD class="xl64" style="border-top: none; border-left: none;">250</TD><TD class="xl64" style="border-top: none; border-left: none;">100</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">C</TD><TD class="xl64" style="border-top: none; border-left: none;">250</TD><TD class="xl64" style="border-top: none; border-left: none;">50</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">C</TD><TD class="xl64" style="border-top: none; border-left: none;">250</TD><TD class="xl64" style="border-top: none; border-left: none;">50</TD></TR><TR><TD class="xl66" height="21" style="border-top: none;">C</TD><TD class="xl67" style="border-top: none; border-left: none;">250</TD><TD class="xl67" style="border-top: none; border-left: none;">10</TD></TR></TBODY></TABLE><P></P><P>and need result like this...</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="294"><TBODY><TR><TD class="xl75" height="21" width="83">PartNumber</TD><TD class="xl76" style="border-left: none;" width="79">Initial Stock</TD><TD class="xl76" style="border-left: none;" width="65">OrderQty</TD><TD class="xl77" style="border-left: none;" width="67">Stock Left</TD></TR><TR><TD class="xl72" height="20">A</TD><TD class="xl73" style="border-left: none;">200</TD><TD class="xl73" style="border-left: none;">100</TD><TD class="xl74" style="border-left: none;">100</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">A</TD><TD class="xl66" style="border-top: none; border-left: none;">200</TD><TD class="xl66" style="border-top: none; border-left: none;">20</TD><TD class="xl68" style="border-top: none; border-left: none;">80</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">A</TD><TD class="xl66" style="border-top: none; border-left: none;">200</TD><TD class="xl66" style="border-top: none; border-left: none;">50</TD><TD class="xl68" style="border-top: none; border-left: none;">30</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">A</TD><TD class="xl66" style="border-top: none; border-left: none;">200</TD><TD class="xl66" style="border-top: none; border-left: none;">20</TD><TD class="xl68" style="border-top: none; border-left: none;">10</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">B</TD><TD class="xl66" style="border-top: none; border-left: none;">300</TD><TD class="xl66" style="border-top: none; border-left: none;">100</TD><TD class="xl68" style="border-top: none; border-left: none;">200</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">B</TD><TD class="xl66" style="border-top: none; border-left: none;">300</TD><TD class="xl66" style="border-top: none; border-left: none;">80</TD><TD class="xl68" style="border-top: none; border-left: none;">120</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">B</TD><TD class="xl66" style="border-top: none; border-left: none;">300</TD><TD class="xl66" style="border-top: none; border-left: none;">20</TD><TD class="xl68" style="border-top: none; border-left: none;">100</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">B</TD><TD class="xl66" style="border-top: none; border-left: none;">300</TD><TD class="xl66" style="border-top: none; border-left: none;">40</TD><TD class="xl68" style="border-top: none; border-left: none;">60</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">B</TD><TD class="xl66" style="border-top: none; border-left: none;">300</TD><TD class="xl66" style="border-top: none; border-left: none;">60</TD><TD class="xl68" style="border-top: none; border-left: none;">0</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">C</TD><TD class="xl66" style="border-top: none; border-left: none;">250</TD><TD class="xl66" style="border-top: none; border-left: none;">100</TD><TD class="xl68" style="border-top: none; border-left: none;">150</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">C</TD><TD class="xl66" style="border-top: none; border-left: none;">250</TD><TD class="xl66" style="border-top: none; border-left: none;">50</TD><TD class="xl68" style="border-top: none; border-left: none;">100</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">C</TD><TD class="xl66" style="border-top: none; border-left: none;">250</TD><TD class="xl66" style="border-top: none; border-left: none;">50</TD><TD class="xl68" style="border-top: none; border-left: none;">50</TD></TR><TR><TD class="xl69" height="21" style="border-top: none;">C</TD><TD class="xl70" style="border-top: none; border-left: none;">250</TD><TD class="xl70" style="border-top: none; border-left: none;">10</TD><TD class="xl71" style="border-top: none; border-left: none;">40</TD></TR></TBODY></TABLE><P></P><P>Let me know asap.</P><P></P><P>UPDATE: Forgot to mention... I need this in UI or chart side... Inside script I can do.</P></BODY></HTML> Thu, 13 Mar 2014 13:18:37 GMT https://community.qlik.com/t5/QlikView/RangeSum-and-Above/m-p/571533#M212941 MK_QSL 2014-03-13T13:18:37Z Re: RangeSum and Above https://community.qlik.com/t5/QlikView/RangeSum-and-Above/m-p/571534#M212942 <HTML><HEAD></HEAD><BODY><P>any reply on this?</P></BODY></HTML> Thu, 13 Mar 2014 15:33:51 GMT https://community.qlik.com/t5/QlikView/RangeSum-and-Above/m-p/571534#M212942 MK_QSL 2014-03-13T15:33:51Z Re: Re: RangeSum and Above https://community.qlik.com/t5/QlikView/RangeSum-and-Above/m-p/571535#M212943 <HTML><HEAD></HEAD><BODY><P>Hi Manish,</P><P></P><P>Have a look! do you want something like this!</P><P></P><P>Vinay</P><P><BR />update:</P><P></P><P>Please use below in expression...</P><P></P><P><SPAN style="color: blue; font-family: 'Arial','sans-serif'; font-size: 9pt;">IF</SPAN><SPAN style="color: black; font-family: 'Arial','sans-serif'; font-size: 9pt;">(</SPAN><SPAN style="color: maroon; font-family: 'Arial','sans-serif'; font-size: 9pt;">PartNumber</SPAN><SPAN style="color: black; font-family: 'Arial','sans-serif'; font-size: 9pt;">&lt;&gt;</SPAN><SPAN style="color: blue; font-family: 'Arial','sans-serif'; font-size: 9pt;">Above</SPAN><SPAN style="color: black; font-family: 'Arial','sans-serif'; font-size: 9pt;">(</SPAN><SPAN style="color: maroon; font-family: 'Arial','sans-serif'; font-size: 9pt;">PartNumber</SPAN><SPAN style="color: black; font-family: 'Arial','sans-serif'; font-size: 9pt;">),</SPAN><SPAN style="color: maroon; font-family: 'Arial','sans-serif'; font-size: 9pt;">[Initial<BR />Stock]</SPAN><SPAN style="color: black; font-family: 'Arial','sans-serif'; font-size: 9pt;">-</SPAN><SPAN style="color: maroon; font-family: 'Arial','sans-serif'; font-size: 9pt;">OrderQty</SPAN><SPAN style="color: black; font-family: 'Arial','sans-serif'; font-size: 9pt;">,</SPAN><SPAN style="color: maroon; font-family: 'Arial','sans-serif'; font-size: 9pt;">[Initial Stock]</SPAN><SPAN style="color: black; font-family: 'Arial','sans-serif'; font-size: 9pt;">-</SPAN><SPAN style="color: blue; font-family: 'Arial','sans-serif'; font-size: 9pt;">RangeSum</SPAN><SPAN style="color: black; font-family: 'Arial','sans-serif'; font-size: 9pt;">(</SPAN><SPAN style="color: blue; font-family: 'Arial','sans-serif'; font-size: 9pt;">Above</SPAN><SPAN style="color: black; font-family: 'Arial','sans-serif'; font-size: 9pt;">(</SPAN><SPAN style="color: blue; font-family: 'Arial','sans-serif'; font-size: 9pt;">SUM</SPAN><SPAN style="color: black; font-family: 'Arial','sans-serif'; font-size: 9pt;">(</SPAN><SPAN style="color: maroon; font-family: 'Arial','sans-serif'; font-size: 9pt;">OrderQty</SPAN><SPAN style="color: black; font-family: 'Arial','sans-serif'; font-size: 9pt;">),0,</SPAN><SPAN style="color: blue; font-family: 'Arial','sans-serif'; font-size: 9pt;">RowNo</SPAN><SPAN style="color: black; font-family: 'Arial','sans-serif'; font-size: 9pt;">()))) </SPAN></P><P> </P><P></P></BODY></HTML> Thu, 13 Mar 2014 16:16:36 GMT https://community.qlik.com/t5/QlikView/RangeSum-and-Above/m-p/571535#M212943 2014-03-13T16:16:36Z Re: RangeSum and Above https://community.qlik.com/t5/QlikView/RangeSum-and-Above/m-p/571536#M212944 <HTML><HEAD></HEAD><BODY><P>See attached qvw.</P></BODY></HTML> Thu, 13 Mar 2014 16:47:29 GMT https://community.qlik.com/t5/QlikView/RangeSum-and-Above/m-p/571536#M212944 Gysbert_Wassenaar 2014-03-13T16:47:29Z Re: RangeSum and Above https://community.qlik.com/t5/QlikView/RangeSum-and-Above/m-p/571537#M212945 <HTML><HEAD></HEAD><BODY><P>Salute to Gysbert,</P><P>You deserve the top rank.... !!! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 13 Mar 2014 17:02:28 GMT https://community.qlik.com/t5/QlikView/RangeSum-and-Above/m-p/571537#M212945 MK_QSL 2014-03-13T17:02:28Z