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: 
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