Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
kennethand
Contributor III
Contributor III

Average of fourth quartile

How do I find the average of the fourth quartile?

I can find the fourth quartile point using this expression: Fractile(Q21Num, 0.75).

But how do I get average of the values belonging to the fourth quartile ?

11 Replies
TKendrick20
Partner - Specialist
Partner - Specialist

That should work, I just had my sign backwards in my example.

AVG({$<[Q21Num] = {">=$(=vFractile)"}>} [Q21Num])

kennethand
Contributor III
Contributor III
Author

Excellent - thanks, it did the trick!