topic Re: Using Fractile with a set modifier in QlikView https://community.qlik.com/t5/QlikView/Using-Fractile-with-a-set-modifier/m-p/538435#M481000 <HTML><HEAD></HEAD><BODY><P>Have you tried </P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">= Fractile({&lt;County= &gt;} TOTAL Aggr(Sum({&lt;County = &gt;} Actual_Utilized_Amount),County),0.75)</SPAN></P></BODY></HTML> Mon, 28 Oct 2013 21:39:22 GMT swuehl 2013-10-28T21:39:22Z Using Fractile with a set modifier https://community.qlik.com/t5/QlikView/Using-Fractile-with-a-set-modifier/m-p/538434#M480999 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I'm using the following expression to work out the upper quartile of my selection:</P><P>=Fractile(TOTAL Aggr(Sum(Actual_Utilized_Amount),County), 0.75)</P><P></P><P>If I select a county, I still want to calculate the upper quartile for all counties, rather than just the selected county. I've tried using a set modifier in my expression but it does not work:</P><P></P><P>= Fractile({&lt;County = &gt;} TOTAL Aggr(Sum( Actual_Utilized_Amount),County),0.75)</P><P>or</P><P>= Fractile(TOTAL Aggr(Sum({&lt;County = &gt;} Actual_Utilized_Amount),County),0.75)</P><P></P><P>What am I doing wrong?</P></BODY></HTML> Mon, 28 Oct 2013 21:25:17 GMT https://community.qlik.com/t5/QlikView/Using-Fractile-with-a-set-modifier/m-p/538434#M480999 2013-10-28T21:25:17Z Re: Using Fractile with a set modifier https://community.qlik.com/t5/QlikView/Using-Fractile-with-a-set-modifier/m-p/538435#M481000 <HTML><HEAD></HEAD><BODY><P>Have you tried </P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">= Fractile({&lt;County= &gt;} TOTAL Aggr(Sum({&lt;County = &gt;} Actual_Utilized_Amount),County),0.75)</SPAN></P></BODY></HTML> Mon, 28 Oct 2013 21:39:22 GMT https://community.qlik.com/t5/QlikView/Using-Fractile-with-a-set-modifier/m-p/538435#M481000 swuehl 2013-10-28T21:39:22Z Re: Using Fractile with a set modifier https://community.qlik.com/t5/QlikView/Using-Fractile-with-a-set-modifier/m-p/538436#M481001 <HTML><HEAD></HEAD><BODY><P>That did the trick nicely. Thank you</P></BODY></HTML> Mon, 28 Oct 2013 22:50:50 GMT https://community.qlik.com/t5/QlikView/Using-Fractile-with-a-set-modifier/m-p/538436#M481001 2013-10-28T22:50:50Z