https://community.qlik.com/t5/App-Development/Set-Analysis-with-Fractile/m-p/1855912#M70638 <P>Hi,</P> <P>I'm trying to write a formula that will average values that are between the 5th percentile and the 95th percentile.&nbsp;</P> <P>Trying to do this with set analysis, but it doesn't seem to be working. What's wrong with the expression below?&nbsp;</P> <P>Thanks</P> <P>avg({&lt;p_is_cl_prev_bps = {"&gt;fractile(total ALL p_is_cl_prev_bps,0.05)"}, p_is_cl_prev_bps = {"&lt;fractile(total ALL p_is_cl_prev_bps,0.95)"}&gt;} p_is_cl_prev_bps)</P> Fri, 05 Nov 2021 08:18:38 GMT johnnyjohn 2021-11-05T08:18:38Z https://community.qlik.com/t5/App-Development/Set-Analysis-with-Fractile/m-p/1855912#M70638 <P>Hi,</P> <P>I'm trying to write a formula that will average values that are between the 5th percentile and the 95th percentile.&nbsp;</P> <P>Trying to do this with set analysis, but it doesn't seem to be working. What's wrong with the expression below?&nbsp;</P> <P>Thanks</P> <P>avg({&lt;p_is_cl_prev_bps = {"&gt;fractile(total ALL p_is_cl_prev_bps,0.05)"}, p_is_cl_prev_bps = {"&lt;fractile(total ALL p_is_cl_prev_bps,0.95)"}&gt;} p_is_cl_prev_bps)</P> Fri, 05 Nov 2021 08:18:38 GMT https://community.qlik.com/t5/App-Development/Set-Analysis-with-Fractile/m-p/1855912#M70638 johnnyjohn 2021-11-05T08:18:38Z