topic Re: Aggr meed help in QlikView https://community.qlik.com/t5/QlikView/Aggr-meed-help/m-p/1054593#M929742 <HTML><HEAD></HEAD><BODY><P>You need this in a text box object?</P></BODY></HTML> Wed, 23 Mar 2016 09:12:34 GMT sunny_talwar 2016-03-23T09:12:34Z Aggr meed help https://community.qlik.com/t5/QlikView/Aggr-meed-help/m-p/1054592#M929741 <HTML><HEAD></HEAD><BODY><P>HI friends</P><P></P><P>i have a table student with two columns student id and marks. </P><P></P><P>Data set as shown below</P><P></P><P>student id.&nbsp;&nbsp; Marks</P><P>15.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 42</P><P>14.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 39</P><P>13,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 22</P><P>11,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 18</P><P>10.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 90</P><P>9.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 72</P><P>8.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 33</P><P>7.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 43</P><P>6.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11</P><P>5.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17</P><P>4.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 38</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 66</P><P>2.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 74</P><P>1,&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P></P><P></P><P>now i wanted so consider latest 11 points i.e frpm15 to 5 </P><P></P><P>then i need average of top 5 and avg of last six that </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Aggr-meed-help/m-p/1054592#M929741 Anonymous 2020-11-25T16:16:04Z Re: Aggr meed help https://community.qlik.com/t5/QlikView/Aggr-meed-help/m-p/1054593#M929742 <HTML><HEAD></HEAD><BODY><P>You need this in a text box object?</P></BODY></HTML> Wed, 23 Mar 2016 09:12:34 GMT https://community.qlik.com/t5/QlikView/Aggr-meed-help/m-p/1054593#M929742 sunny_talwar 2016-03-23T09:12:34Z Re: Aggr meed help https://community.qlik.com/t5/QlikView/Aggr-meed-help/m-p/1054594#M929743 <HTML><HEAD></HEAD><BODY><P>May be this in a text box object</P><P></P><P>For Top 5</P><P><STRONG>=Avg(Aggr(If(Rank(If(Rank([student id]) &lt;= 10, Marks)) &lt;= 5, Marks), [student id]))</STRONG></P><P></P><P>For Bottom 5</P><P><STRONG style="font-size: 13.3333px;">=Avg(Aggr(If(Rank(If(Rank([student id]) &lt;= 10, Marks)) &gt; 5, Marks), [student id]))</STRONG></P><P></P><P>NOTE: 15 to 5 are just 10 data points so I used Bottom 5 instead of bottom 6 here</P></BODY></HTML> Wed, 23 Mar 2016 09:19:44 GMT https://community.qlik.com/t5/QlikView/Aggr-meed-help/m-p/1054594#M929743 sunny_talwar 2016-03-23T09:19:44Z Re: Aggr meed help https://community.qlik.com/t5/QlikView/Aggr-meed-help/m-p/1054595#M929744 <HTML><HEAD></HEAD><BODY><P>‌yes </P></BODY></HTML> Wed, 23 Mar 2016 09:20:34 GMT https://community.qlik.com/t5/QlikView/Aggr-meed-help/m-p/1054595#M929744 Anonymous 2016-03-23T09:20:34Z