topic Range Sum above based on specific group issue in QlikView https://community.qlik.com/t5/QlikView/Range-Sum-above-based-on-specific-group-issue/m-p/184364#M49285 <HTML><HEAD></HEAD><BODY><P>HI,</P><P>I hope this application helps you out.</P></BODY></HTML> Sat, 13 Nov 2010 06:58:42 GMT deepakk 2010-11-13T06:58:42Z Range Sum above based on specific group issue https://community.qlik.com/t5/QlikView/Range-Sum-above-based-on-specific-group-issue/m-p/184363#M49284 <HTML><HEAD></HEAD><BODY><P>I have requirement to get the values</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 215pt; border-collapse: collapse;" width="285"><COLGROUP><COL style="width: 74pt; mso-width-source: userset; mso-width-alt: 3584; mso-outline-parent: collapsed;" width="98" /><COL style="width: 67pt; mso-width-source: userset; mso-width-alt: 3254; mso-outline-parent: collapsed;" width="89" /><COL style="width: 74pt; mso-width-source: userset; mso-width-alt: 3584; mso-outline-parent: collapsed;" width="98" /></COLGROUP><TBODY><TR height="18" style="height: 13.5pt;"><TD height="18" style="width: 74pt; height: 13.5pt; background-color: transparent; border: #f0f0f0;" width="98"></TD><TD style="width: 67pt; background-color: transparent; border: #f0f0f0;" width="89"></TD><TD style="width: 74pt; background-color: transparent; border: #f0f0f0;" width="98"></TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl65" height="17" style="border-right: black 0.5pt solid; border-top: black 1pt solid; border-left: black 0.5pt solid; border-bottom: black 0.5pt solid; height: 12.75pt; background-color: #e1e1e1;">Month</TD><TD class="xl66" style="border-right: black 1pt solid; border-top: black 1pt solid; border-left: black; border-bottom: black 0.5pt solid; background-color: #e1e1e1;">SalesGroup</TD><TD class="xl67" style="background-color: white; border: black 0.5pt solid;">#Sales</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl67" height="17" style="border-right: black 0.5pt solid; border-top: black; border-left: black 0.5pt solid; border-bottom: black 0.5pt solid; height: 12.75pt; background-color: white;">Jan 2010</TD><TD class="xl67" style="border-right: black 0.5pt solid; border-top: black; border-left: black; border-bottom: black 0.5pt solid; background-color: white;">SYA</TD><TD align="right" class="xl68" style="border-right: black 0.5pt solid; border-top: black; border-left: black; border-bottom: black 0.5pt solid; background-color: white;">1</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl67" height="17" style="border-right: black 0.5pt solid; border-top: black; border-left: black 0.5pt solid; border-bottom: black 0.5pt solid; height: 12.75pt; background-color: white;">Jan 2010</TD><TD class="xl67" style="border-right: black 0.5pt solid; border-top: black; border-left: black; border-bottom: black 0.5pt solid; background-color: white;">SYE</TD><TD align="right" class="xl68" style="border-right: black 0.5pt solid; border-top: black; border-left: black; border-bottom: black 0.5pt solid; background-color: white;">185</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl67" height="17" style="border-right: black 0.5pt solid; border-top: black; border-left: black 0.5pt solid; border-bottom: black 0.5pt solid; height: 12.75pt; background-color: white;">Jan 2010</TD><TD class="xl67" style="border-right: black 0.5pt solid; border-top: black; border-left: black; border-bottom: black 0.5pt solid; background-color: white;">SYM</TD><TD align="right" class="xl68" style="border-right: black 0.5pt solid; border-top: black; border-left: black; border-bottom: black 0.5pt solid; background-color: white;">562</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl67" height="17" style="border-right: black 0.5pt solid; border-top: black; border-left: black 0.5pt solid; border-bottom: black 0.5pt solid; height: 12.75pt; background-color: white;">Feb 2010</TD><TD class="xl67" style="border-right: black 0.5pt solid; border-top: black; border-left: black; border-bottom: black 0.5pt solid; background-color: white;">SYA</TD><TD align="right" class="xl68" style="border-right: black 0.5pt solid; border-top: black; border-left: black; border-bottom: black 0.5pt solid; background-color: white;">1</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl67" height="17" style="border-right: black 0.5pt solid; border-top: black; border-left: black 0.5pt solid; border-bottom: black 0.5pt solid; height: 12.75pt; background-color: white;">Feb 2010</TD><TD class="xl67" style="border-right: black 0.5pt solid; border-top: black; border-left: black; border-bottom: black 0.5pt solid; background-color: white;">SYE</TD><TD align="right" class="xl68" style="border-right: black 0.5pt solid; border-top: black; border-left: black; border-bottom: black 0.5pt solid; background-color: white;">143</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl67" height="17" style="border-right: black 0.5pt solid; border-top: black; border-left: black 0.5pt solid; border-bottom: black 0.5pt solid; height: 12.75pt; background-color: white;">Feb 2010</TD><TD class="xl67" style="border-right: black 0.5pt solid; border-top: black; border-left: black; border-bottom: black 0.5pt solid; background-color: white;">SYM</TD><TD align="right" class="xl68" style="border-right: black 0.5pt solid; border-top: black; border-left: black; border-bottom: black 0.5pt solid; background-color: white;">571</TD></TR></TBODY></TABLE><BR /><BR /> <P></P><P>expected results is Sales Group has to be accumulated to each group SYA for each period -shown values in the #Expected Results Column</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 313pt; border-collapse: collapse;" width="416"><COLGROUP><COL style="width: 74pt; mso-width-source: userset; mso-width-alt: 3584; mso-outline-parent: collapsed;" width="98" /><COL style="width: 67pt; mso-width-source: userset; mso-width-alt: 3254; mso-outline-parent: collapsed;" width="89" /><COL style="width: 74pt; mso-width-source: userset; mso-width-alt: 3584; mso-outline-parent: collapsed;" width="98" /><COL style="width: 98pt; mso-width-source: userset; mso-width-alt: 4790; mso-outline-parent: collapsed;" width="131" /></COLGROUP><TBODY><TR height="17" style="height: 12.75pt;"><TD class="xl63" height="17" style="border-right: black 0.5pt solid; border-top: black 1pt solid; border-left: black 0.5pt solid; width: 74pt; border-bottom: black 0.5pt solid; height: 12.75pt; background-color: #e1e1e1;" width="98">Month</TD><TD class="xl64" style="border-right: black 1pt solid; border-top: black 1pt solid; border-left: black; width: 67pt; border-bottom: black 0.5pt solid; background-color: #e1e1e1;" width="89">SalesGroup</TD><TD class="xl65" style="width: 74pt; background-color: white; border: black 0.5pt solid;" width="98">#Sales</TD><TD class="xl65" style="border-right: black 0.5pt solid; border-top: black 0.5pt solid; border-left: black; width: 98pt; border-bottom: black 0.5pt solid; background-color: white;" width="131"># Expected Results</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl65" height="17" style="border-right: black 0.5pt solid; border-top: black; border-left: black 0.5pt solid; border-bottom: black 0.5pt solid; height: 12.75pt; background-color: white;">Jan 2010</TD><TD class="xl65" style="border-right: black 0.5pt solid; border-top: black; border-left: black; border-bottom: black 0.5pt solid; background-color: white;">SYA</TD><TD align="right" class="xl66" style="border-right: black 0.5pt solid; border-top: black; border-left: black; border-bottom: black 0.5pt solid; background-color: white;">1</TD><TD align="right" class="xl65" style="border-right: black 0.5pt solid; border-top: black; border-left: black; border-bottom: black 0.5pt solid; background-color: white;">1</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl65" height="17" style="border-right: black 0.5pt solid; border-top: black; border-left: black 0.5pt solid; border-bottom: black 0.5pt solid; height: 12.75pt; background-color: white;">Jan 2010</TD><TD class="xl65" style="border-right: black 0.5pt solid; border-top: black; border-left: black; border-bottom: black 0.5pt solid; background-color: white;">SYE</TD><TD align="right" class="xl66" style="border-right: black 0.5pt solid; border-top: black; border-left: black; border-bottom: black 0.5pt solid; background-color: white;">185</TD><TD align="right" class="xl65" style="border-right: black 0.5pt solid; border-top: black; border-left: black; border-bottom: black 0.5pt solid; background-color: white;">186</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl65" height="17" style="border-right: black 0.5pt solid; border-top: black; border-left: black 0.5pt solid; border-bottom: black 0.5pt solid; height: 12.75pt; background-color: white;">Jan 2010</TD><TD class="xl65" style="border-right: black 0.5pt solid; border-top: black; border-left: black; border-bottom: black 0.5pt solid; background-color: white;">SYM</TD><TD align="right" class="xl66" style="border-right: black 0.5pt solid; border-top: black; border-left: black; border-bottom: black 0.5pt solid; background-color: white;">562</TD><TD align="right" class="xl65" style="border-right: black 0.5pt solid; border-top: black; border-left: black; border-bottom: black 0.5pt solid; background-color: white;">748</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl65" height="17" style="border-right: black 0.5pt solid; border-top: black; border-left: black 0.5pt solid; border-bottom: black 0.5pt solid; height: 12.75pt; background-color: white;">Feb 2010</TD><TD class="xl65" style="border-right: black 0.5pt solid; border-top: black; border-left: black; border-bottom: black 0.5pt solid; background-color: white;">SYA</TD><TD align="right" class="xl66" style="border-right: black 0.5pt solid; border-top: black; border-left: black; border-bottom: black 0.5pt solid; background-color: white;">1</TD><TD align="right" class="xl65" style="border-right: black 0.5pt solid; border-top: black; border-left: black; border-bottom: black 0.5pt solid; background-color: white;">2</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl65" height="17" style="border-right: black 0.5pt solid; border-top: black; border-left: black 0.5pt solid; border-bottom: black 0.5pt solid; height: 12.75pt; background-color: white;">Feb 2010</TD><TD class="xl65" style="border-right: black 0.5pt solid; border-top: black; border-left: black; border-bottom: black 0.5pt solid; background-color: white;">SYE</TD><TD align="right" class="xl66" style="border-right: black 0.5pt solid; border-top: black; border-left: black; border-bottom: black 0.5pt solid; background-color: white;">143</TD><TD align="right" class="xl65" style="border-right: black 0.5pt solid; border-top: black; border-left: black; border-bottom: black 0.5pt solid; background-color: white;">328</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl65" height="17" style="border-right: black 0.5pt solid; border-top: black; border-left: black 0.5pt solid; border-bottom: black 0.5pt solid; height: 12.75pt; background-color: white;">Feb 2010</TD><TD class="xl65" style="border-right: black 0.5pt solid; border-top: black; border-left: black; border-bottom: black 0.5pt solid; background-color: white;">SYM</TD><TD align="right" class="xl66" style="border-right: black 0.5pt solid; border-top: black; border-left: black; border-bottom: black 0.5pt solid; background-color: white;">571</TD><TD align="right" class="xl65" style="border-right: black 0.5pt solid; border-top: black; border-left: black; border-bottom: black 0.5pt solid; background-color: white;">1133</TD></TR></TBODY></TABLE><BR /><BR /> <P></P><P>I tried</P><P>rangesum(above(count(distinct Sales),0,RowNo()))</P><P>I have option to select SalesGroup in the layout.</P><P>Advance Thanks for your help.</P><P></P></BODY></HTML> Fri, 12 Nov 2010 11:52:18 GMT https://community.qlik.com/t5/QlikView/Range-Sum-above-based-on-specific-group-issue/m-p/184363#M49284 2010-11-12T11:52:18Z Range Sum above based on specific group issue https://community.qlik.com/t5/QlikView/Range-Sum-above-based-on-specific-group-issue/m-p/184364#M49285 <HTML><HEAD></HEAD><BODY><P>HI,</P><P>I hope this application helps you out.</P></BODY></HTML> Sat, 13 Nov 2010 06:58:42 GMT https://community.qlik.com/t5/QlikView/Range-Sum-above-based-on-specific-group-issue/m-p/184364#M49285 deepakk 2010-11-13T06:58:42Z