topic Help needed, on Rangeavg [ How to exclude a Dimension when calculating RangeSum ] in QlikView https://community.qlik.com/t5/QlikView/Help-needed-on-Rangeavg-How-to-exclude-a-Dimension-when/m-p/242673#M92736 <HTML><HEAD></HEAD><BODY><P>Hi, <EM><STRONG>John Witherspoon</STRONG></EM> I need your help urgently</P><P>Please help me to calculate the the Average Amount of next 3 coming row in a straight table chart but want to exclude some dimension when calculating RangeAvg, on every row like the table</P><P></P><P>I want to exclude the <EM><STRONG>Dimension Design, SNo. </STRONG></EM>in calculation of <EM><STRONG>RangeAvg</STRONG></EM></P><P><EM><STRONG><BR /></STRONG></EM></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="291" style="cursor: default; border-collapse: collapse; margin-top: -1px; margin-right: -1px; margin-bottom: 2px; margin-left: -1px; border: inherit; height: 249px; width: 330px; border-width: 1px; border-color: #000000; border-style: solid;"><TBODY style="border-style: solid;"><TR style="border: inherit; border-color: inherit; border-width: inherit; border-style: solid;"><TH align="center" style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit; background-color: #6690bc;" valign="middle"><P><STRONG>Customer</STRONG></P></TH><TH align="center" style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit; background-color: #6690bc;" valign="middle"><STRONG>Design</STRONG></TH><TH align="center" style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit; background-color: #6690bc;" valign="middle"><STRONG>Machine</STRONG></TH><TH align="center" style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit; background-color: #6690bc;" valign="middle"><STRONG>SNo.</STRONG></TH><TH align="center" style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit; background-color: #6690bc;" valign="middle"><P><STRONG>Sales</STRONG></P><P><STRONG>Amount<BR /></STRONG></P></TH><TH align="center" style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit; background-color: #6690bc;" valign="middle"><P><SPAN style="color: #ffffff;"><STRONG>sum</STRONG></SPAN></P><P><SPAN style="color: #ffffff;"><STRONG>next&nbsp; 3 rows<BR /></STRONG></SPAN></P></TH><TH align="center" style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit; background-color: #6690bc;" valign="middle"><P><EM style="color: #ffffff;"><STRONG> </STRONG></EM></P><P><EM style="color: #ffffff;"><STRONG>Average<BR /></STRONG></EM></P></TH></TR><TR style="border: inherit; border-color: inherit; border-width: inherit; border-style: solid;"><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">A</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">D-1</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">Mc-1</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">1</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;"><P>50</P></TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">70</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">35</TD></TR><TR style="border: inherit; border-color: inherit; border-width: inherit; border-style: solid;"><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">A</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">D-1</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">Mc-1</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">2</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">45</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">25</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">25</TD></TR><TR style="border: inherit; border-color: inherit; border-width: inherit; border-style: solid;"><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">A</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">D-1</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">Mc-1</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">3</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">25</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">0</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">0</TD></TR><TR style="border: inherit; border-color: inherit; border-width: inherit; border-style: solid;"><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">A</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">D-1</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">Mc-2</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">4</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">75</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">0</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">0</TD></TR><TR style="border: inherit; border-color: inherit; border-width: inherit; border-style: solid;"><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">B</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">D-5</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">Mc-1</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">5</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">40</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">25</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">25</TD></TR><TR style="border: inherit; border-color: inherit; border-width: inherit; border-style: solid;"><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">B</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">D-5</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">Mc-1</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">6</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">25</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">0</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">0</TD></TR><TR style="border: inherit; border-color: inherit; border-width: inherit; border-style: solid;"><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">B</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">D-5</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">Mc-2</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">7</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">30</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">0</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">0</TD></TR><TR style="border: inherit; border-color: inherit; border-width: inherit; border-style: solid;"><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">C</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">D-1</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">Mc-1</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">8</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">40</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">0</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">0</TD></TR><TR style="border: inherit; border-color: inherit; border-width: inherit; border-style: solid;"><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">C</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">D-1</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">Mc-2</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">9</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">30</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">50</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">50</TD></TR><TR style="border: inherit; border-color: inherit; border-width: inherit; border-style: solid;"><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">C</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">D-2</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">Mc-2</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">10</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">50</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">0</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">0</TD></TR><TR style="border: inherit; border-color: inherit; border-width: inherit; border-style: solid;"><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">D</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">D-1</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">Mc-1</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">11</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">20</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">0</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">0</TD></TR></TBODY></TABLE><P></P><P>SNo. value of this column is comming from sql query [ Row_Number()&nbsp; ], it is a running no</P><P>Last column is my desired result</P><P>I am attaching QVW sample here</P><P></P><P>thanks &amp; regars</P><P></P><P>bb</P></BODY></HTML> Mon, 21 Nov 2011 10:06:44 GMT 2011-11-21T10:06:44Z Help needed, on Rangeavg [ How to exclude a Dimension when calculating RangeSum ] https://community.qlik.com/t5/QlikView/Help-needed-on-Rangeavg-How-to-exclude-a-Dimension-when/m-p/242673#M92736 <HTML><HEAD></HEAD><BODY><P>Hi, <EM><STRONG>John Witherspoon</STRONG></EM> I need your help urgently</P><P>Please help me to calculate the the Average Amount of next 3 coming row in a straight table chart but want to exclude some dimension when calculating RangeAvg, on every row like the table</P><P></P><P>I want to exclude the <EM><STRONG>Dimension Design, SNo. </STRONG></EM>in calculation of <EM><STRONG>RangeAvg</STRONG></EM></P><P><EM><STRONG><BR /></STRONG></EM></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="291" style="cursor: default; border-collapse: collapse; margin-top: -1px; margin-right: -1px; margin-bottom: 2px; margin-left: -1px; border: inherit; height: 249px; width: 330px; border-width: 1px; border-color: #000000; border-style: solid;"><TBODY style="border-style: solid;"><TR style="border: inherit; border-color: inherit; border-width: inherit; border-style: solid;"><TH align="center" style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit; background-color: #6690bc;" valign="middle"><P><STRONG>Customer</STRONG></P></TH><TH align="center" style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit; background-color: #6690bc;" valign="middle"><STRONG>Design</STRONG></TH><TH align="center" style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit; background-color: #6690bc;" valign="middle"><STRONG>Machine</STRONG></TH><TH align="center" style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit; background-color: #6690bc;" valign="middle"><STRONG>SNo.</STRONG></TH><TH align="center" style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit; background-color: #6690bc;" valign="middle"><P><STRONG>Sales</STRONG></P><P><STRONG>Amount<BR /></STRONG></P></TH><TH align="center" style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit; background-color: #6690bc;" valign="middle"><P><SPAN style="color: #ffffff;"><STRONG>sum</STRONG></SPAN></P><P><SPAN style="color: #ffffff;"><STRONG>next&nbsp; 3 rows<BR /></STRONG></SPAN></P></TH><TH align="center" style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit; background-color: #6690bc;" valign="middle"><P><EM style="color: #ffffff;"><STRONG> </STRONG></EM></P><P><EM style="color: #ffffff;"><STRONG>Average<BR /></STRONG></EM></P></TH></TR><TR style="border: inherit; border-color: inherit; border-width: inherit; border-style: solid;"><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">A</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">D-1</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">Mc-1</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">1</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;"><P>50</P></TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">70</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">35</TD></TR><TR style="border: inherit; border-color: inherit; border-width: inherit; border-style: solid;"><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">A</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">D-1</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">Mc-1</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">2</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">45</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">25</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">25</TD></TR><TR style="border: inherit; border-color: inherit; border-width: inherit; border-style: solid;"><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">A</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">D-1</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">Mc-1</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">3</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">25</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">0</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">0</TD></TR><TR style="border: inherit; border-color: inherit; border-width: inherit; border-style: solid;"><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">A</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">D-1</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">Mc-2</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">4</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">75</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">0</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">0</TD></TR><TR style="border: inherit; border-color: inherit; border-width: inherit; border-style: solid;"><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">B</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">D-5</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">Mc-1</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">5</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">40</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">25</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">25</TD></TR><TR style="border: inherit; border-color: inherit; border-width: inherit; border-style: solid;"><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">B</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">D-5</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">Mc-1</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">6</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">25</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">0</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">0</TD></TR><TR style="border: inherit; border-color: inherit; border-width: inherit; border-style: solid;"><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">B</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">D-5</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">Mc-2</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">7</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">30</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">0</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">0</TD></TR><TR style="border: inherit; border-color: inherit; border-width: inherit; border-style: solid;"><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">C</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">D-1</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">Mc-1</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">8</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">40</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">0</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">0</TD></TR><TR style="border: inherit; border-color: inherit; border-width: inherit; border-style: solid;"><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">C</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">D-1</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">Mc-2</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">9</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">30</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">50</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">50</TD></TR><TR style="border: inherit; border-color: inherit; border-width: inherit; border-style: solid;"><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">C</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">D-2</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">Mc-2</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">10</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">50</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">0</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">0</TD></TR><TR style="border: inherit; border-color: inherit; border-width: inherit; border-style: solid;"><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">D</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">D-1</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">Mc-1</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">11</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">20</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">0</TD><TD style="border-collapse: collapse; cursor: text; border-color: inherit; font-weight: normal; border: inherit;">0</TD></TR></TBODY></TABLE><P></P><P>SNo. value of this column is comming from sql query [ Row_Number()&nbsp; ], it is a running no</P><P>Last column is my desired result</P><P>I am attaching QVW sample here</P><P></P><P>thanks &amp; regars</P><P></P><P>bb</P></BODY></HTML> Mon, 21 Nov 2011 10:06:44 GMT https://community.qlik.com/t5/QlikView/Help-needed-on-Rangeavg-How-to-exclude-a-Dimension-when/m-p/242673#M92736 2011-11-21T10:06:44Z