2 Replies Latest reply: Feb 20, 2014 8:36 AM by Erica Whalley RSS

    Truncated Average, or "trimmed mean"

    Nate Schroeder

      Is there a way to calculate a truncated average or "trimmed mean" in Qlikview? I would like to include this in a straight table or a pivot table.  In Excel there is a function for this called TRIMMEAN.  This allows you to calculate an average that excludes outlying values.  You specify a percentage of high and low values to exclude.  I don't see anything like this listed under the "Aggregate" function category.