topic Trimmed Median in QlikView https://community.qlik.com/t5/QlikView/Trimmed-Median/m-p/184122#M49140 <HTML><HEAD></HEAD><BODY><P>I think this:</P><P style="padding-left:30px;">avg(if(Value&gt;fractile(total Value,.05)<BR /> and Value&lt;fractile(total Value,.95),Value))</P><P>The fractile expressions figure out the values that the bottom 5% are below and the top 5% are above. Then we look for Values between these two limits. Finally, we take the average of those values.</P></BODY></HTML> Sat, 12 Sep 2009 03:54:46 GMT johnw 2009-09-12T03:54:46Z Trimmed Median https://community.qlik.com/t5/QlikView/Trimmed-Median/m-p/184121#M49139 <HTML><HEAD></HEAD><BODY><P>Does anyone know the expression for a trimmed median? We are looking to trim the bottom 5% and the top 5%.</P><P></P><P>Thanks!</P><P>Christine Thies, Austin Fire Department</P></BODY></HTML> Sat, 12 Sep 2009 03:39:55 GMT https://community.qlik.com/t5/QlikView/Trimmed-Median/m-p/184121#M49139 2009-09-12T03:39:55Z Trimmed Median https://community.qlik.com/t5/QlikView/Trimmed-Median/m-p/184122#M49140 <HTML><HEAD></HEAD><BODY><P>I think this:</P><P style="padding-left:30px;">avg(if(Value&gt;fractile(total Value,.05)<BR /> and Value&lt;fractile(total Value,.95),Value))</P><P>The fractile expressions figure out the values that the bottom 5% are below and the top 5% are above. Then we look for Values between these two limits. Finally, we take the average of those values.</P></BODY></HTML> Sat, 12 Sep 2009 03:54:46 GMT https://community.qlik.com/t5/QlikView/Trimmed-Median/m-p/184122#M49140 johnw 2009-09-12T03:54:46Z Trimmed Median https://community.qlik.com/t5/QlikView/Trimmed-Median/m-p/184123#M49141 <HTML><HEAD></HEAD><BODY><P>Thanks! And on a Friday afternoon.... <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Sat, 12 Sep 2009 05:10:26 GMT https://community.qlik.com/t5/QlikView/Trimmed-Median/m-p/184123#M49141 2009-09-12T05:10:26Z