Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculating average after removing min and max

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.  Does anyone have any suggestions?

An expression like:

( sum(value) - max(value) - min(value) ) / (count(value)-2)

6 Replies
simondachstr
Specialist III
Specialist III

What's wrong with your expression? Alternatively, you can also use set analysis.

Not applicable
Author

Yes, the expression does seem to be working - it's just not getting the value I would expect.  Could you demonstrate the set analysis way?

simondachstr
Specialist III
Specialist III

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.

JonnyPoole
Former Employee
Former Employee

Which part is incorrect ?  The denominator , numerator or both ?  I would split apart the components and test each one. There is really only 3 or 4 values that need validating.

Not applicable
Author

yah it's working fine, now ended up being a bracket misplacement

JonnyPoole
Former Employee
Former Employee

cool... mark your last response as correct and close er' down.