topic Re: Average below and above in QlikView https://community.qlik.com/t5/QlikView/Average-below-and-above/m-p/332378#M122453 <HTML><HEAD></HEAD><BODY><P>In your chart try this expression:</P><P></P><P>RangeAvg(Above(Sum(YourField),10,20))</P><P></P><P>Hope this helps,</P><P></P><P>Jason</P></BODY></HTML> Tue, 03 Jul 2012 18:49:32 GMT Jason_Michaelides 2012-07-03T18:49:32Z Average below and above https://community.qlik.com/t5/QlikView/Average-below-and-above/m-p/332377#M122452 <HTML><HEAD></HEAD><BODY><P><SPAN id="result_box" lang="en"><SPAN class="hps">I need to calculate</SPAN> <SPAN class="hps">the average of the</SPAN> <SPAN class="hps">10 entries</SPAN> <SPAN class="hps">below and</SPAN> <SPAN class="hps">above</SPAN> of a field in <SPAN class="hps">the script</SPAN></SPAN></P></BODY></HTML> Tue, 03 Jul 2012 18:44:43 GMT https://community.qlik.com/t5/QlikView/Average-below-and-above/m-p/332377#M122452 2012-07-03T18:44:43Z Re: Average below and above https://community.qlik.com/t5/QlikView/Average-below-and-above/m-p/332378#M122453 <HTML><HEAD></HEAD><BODY><P>In your chart try this expression:</P><P></P><P>RangeAvg(Above(Sum(YourField),10,20))</P><P></P><P>Hope this helps,</P><P></P><P>Jason</P></BODY></HTML> Tue, 03 Jul 2012 18:49:32 GMT https://community.qlik.com/t5/QlikView/Average-below-and-above/m-p/332378#M122453 Jason_Michaelides 2012-07-03T18:49:32Z Re: Average below and above https://community.qlik.com/t5/QlikView/Average-below-and-above/m-p/332379#M122454 <HTML><HEAD></HEAD><BODY><P>PS you might need -10 as the second parameter for Above(). I can't remember if the offset goes up or down...</P></BODY></HTML> Tue, 03 Jul 2012 18:50:28 GMT https://community.qlik.com/t5/QlikView/Average-below-and-above/m-p/332379#M122454 Jason_Michaelides 2012-07-03T18:50:28Z Re: Average below and above https://community.qlik.com/t5/QlikView/Average-below-and-above/m-p/332380#M122455 <HTML><HEAD></HEAD><BODY><P>Thanks</P></BODY></HTML> Tue, 03 Jul 2012 19:41:18 GMT https://community.qlik.com/t5/QlikView/Average-below-and-above/m-p/332380#M122455 2012-07-03T19:41:18Z Re: Average below and above https://community.qlik.com/t5/QlikView/Average-below-and-above/m-p/332381#M122456 <HTML><HEAD></HEAD><BODY><P>Thanks...</P><P><SPAN class="hps">If I</SPAN> <SPAN class="hps">can not find</SPAN> <SPAN class="hps">how to do it</SPAN> <SPAN class="hps">in the script</SPAN><SPAN>, I will do</SPAN> <SPAN class="hps">in the graph as</SPAN> <SPAN class="hps">you show me</SPAN></P></BODY></HTML> Tue, 03 Jul 2012 19:43:50 GMT https://community.qlik.com/t5/QlikView/Average-below-and-above/m-p/332381#M122456 2012-07-03T19:43:50Z Re: Average below and above https://community.qlik.com/t5/QlikView/Average-below-and-above/m-p/332382#M122457 <HTML><HEAD></HEAD><BODY><P>Thanks...</P><P><SPAN class="hps">If I</SPAN> <SPAN class="hps">can not find</SPAN> <SPAN class="hps">how to do it</SPAN> <SPAN class="hps">in the script</SPAN>, I will do <SPAN class="hps">in the graph as</SPAN> <SPAN class="hps">you show me</SPAN></P></BODY></HTML> Tue, 03 Jul 2012 19:44:41 GMT https://community.qlik.com/t5/QlikView/Average-below-and-above/m-p/332382#M122457 2012-07-03T19:44:41Z Re: Average below and above https://community.qlik.com/t5/QlikView/Average-below-and-above/m-p/332383#M122458 <HTML><HEAD></HEAD><BODY><P>If you need to do it in the script look at using Peek()</P></BODY></HTML> Tue, 03 Jul 2012 19:45:00 GMT https://community.qlik.com/t5/QlikView/Average-below-and-above/m-p/332383#M122458 Jason_Michaelides 2012-07-03T19:45:00Z