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

Announcements
April 13–15 - Dare to Unleash a New Professional You at Qlik Connect 2026: Register Now!
cancel
Showing results for 
Search instead for 
Did you mean: 
johnnyjohn
Creator
Creator

Set Analysis with Fractile

Hi,

I'm trying to write a formula that will average values that are between the 5th percentile and the 95th percentile. 

Trying to do this with set analysis, but it doesn't seem to be working. What's wrong with the expression below? 

Thanks

avg({<p_is_cl_prev_bps = {">fractile(total ALL p_is_cl_prev_bps,0.05)"}, p_is_cl_prev_bps = {"<fractile(total ALL p_is_cl_prev_bps,0.95)"}>} p_is_cl_prev_bps)

0 Replies