topic Re: Calculating average after removing min and max in QlikView https://community.qlik.com/t5/QlikView/Calculating-average-after-removing-min-and-max/m-p/726332#M537137 <HTML><HEAD></HEAD><BODY><P>Which part is incorrect ?&nbsp; The denominator , numerator or both ?&nbsp; I would split apart the components and test each one. There is really only 3 or 4 values that need validating. </P></BODY></HTML> Wed, 29 Oct 2014 17:01:46 GMT JonnyPoole 2014-10-29T17:01:46Z Calculating average after removing min and max https://community.qlik.com/t5/QlikView/Calculating-average-after-removing-min-and-max/m-p/726328#M537133 <HTML><HEAD></HEAD><BODY><P>I am trying to find a clean way to calculate average in a pivot chart after removing the min and max values of each row.&nbsp; Does anyone have any suggestions?</P><P></P><P>An expression like:</P><P></P><P>( sum(value) - max(value) - min(value) ) / (count(value)-2)</P></BODY></HTML> Wed, 29 Oct 2014 16:16:00 GMT https://community.qlik.com/t5/QlikView/Calculating-average-after-removing-min-and-max/m-p/726328#M537133 2014-10-29T16:16:00Z Re: Calculating average after removing min and max https://community.qlik.com/t5/QlikView/Calculating-average-after-removing-min-and-max/m-p/726329#M537134 <HTML><HEAD></HEAD><BODY><P>What's wrong with your expression? Alternatively, you can also use set analysis.</P></BODY></HTML> Wed, 29 Oct 2014 16:18:28 GMT https://community.qlik.com/t5/QlikView/Calculating-average-after-removing-min-and-max/m-p/726329#M537134 simondachstr 2014-10-29T16:18:28Z Re: Calculating average after removing min and max https://community.qlik.com/t5/QlikView/Calculating-average-after-removing-min-and-max/m-p/726330#M537135 <HTML><HEAD></HEAD><BODY><P>Yes, the expression does seem to be working - it's just not getting the value I would expect.&nbsp; Could you demonstrate the set analysis way?</P></BODY></HTML> Wed, 29 Oct 2014 16:39:50 GMT https://community.qlik.com/t5/QlikView/Calculating-average-after-removing-min-and-max/m-p/726330#M537135 2014-10-29T16:39:50Z Re: Calculating average after removing min and max https://community.qlik.com/t5/QlikView/Calculating-average-after-removing-min-and-max/m-p/726331#M537136 <HTML><HEAD></HEAD><BODY><P>I would first investigate why your expression is not working as of now - set analysis would do nothing else than translating your expression into a set modifier.</P></BODY></HTML> Wed, 29 Oct 2014 17:00:02 GMT https://community.qlik.com/t5/QlikView/Calculating-average-after-removing-min-and-max/m-p/726331#M537136 simondachstr 2014-10-29T17:00:02Z Re: Calculating average after removing min and max https://community.qlik.com/t5/QlikView/Calculating-average-after-removing-min-and-max/m-p/726332#M537137 <HTML><HEAD></HEAD><BODY><P>Which part is incorrect ?&nbsp; The denominator , numerator or both ?&nbsp; I would split apart the components and test each one. There is really only 3 or 4 values that need validating. </P></BODY></HTML> Wed, 29 Oct 2014 17:01:46 GMT https://community.qlik.com/t5/QlikView/Calculating-average-after-removing-min-and-max/m-p/726332#M537137 JonnyPoole 2014-10-29T17:01:46Z Re: Calculating average after removing min and max https://community.qlik.com/t5/QlikView/Calculating-average-after-removing-min-and-max/m-p/726333#M537138 <HTML><HEAD></HEAD><BODY><P>yah it's working fine, now ended up being a bracket misplacement</P></BODY></HTML> Wed, 29 Oct 2014 18:13:15 GMT https://community.qlik.com/t5/QlikView/Calculating-average-after-removing-min-and-max/m-p/726333#M537138 2014-10-29T18:13:15Z Re: Calculating average after removing min and max https://community.qlik.com/t5/QlikView/Calculating-average-after-removing-min-and-max/m-p/726334#M537139 <HTML><HEAD></HEAD><BODY><P>cool... mark your last response as correct and close er' down.</P></BODY></HTML> Wed, 29 Oct 2014 20:23:38 GMT https://community.qlik.com/t5/QlikView/Calculating-average-after-removing-min-and-max/m-p/726334#M537139 JonnyPoole 2014-10-29T20:23:38Z