topic Problem using Fractile with Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Problem-using-Fractile-with-Set-Analysis/m-p/207592#M63293 <HTML><HEAD></HEAD><BODY><P>Hello,<BR /><BR />I have created an expression using fractile that returns a value of 5% for physicians. When comparing all physicians, the correct value is returned. However, when I select one or more physicians from a list, my return value changes. Can anyone tell me what I need to add to my script so that the value stays static (meaning it will ignore any selections I make from a list of physicians.<BR /><BR />fractile(aggr(count({&lt;IBEX_DISPOSITION_ATN_NAME=, RETURN_QUALIFIER={'1'}&gt;}IBEX_NUM) / (count({&lt;IBEX_DISPOSITION_ATN_NAME=, RETURN_QUALIFIER={'1'}&gt;}IBEX_NUM) + count({&lt;IBEX_DISPOSITION_ATN_NAME=, RETURN_QUALIFIER={'0'}&gt;}IBEX_NUM)),IBEX_DISPOSITION_ATN_LOGIN_ID),0.05)<BR /><BR />Thanks!!<BR /><BR />Scott<BR /><BR /></P><P></P><P></P><P></P><P></P><P></P><BR /><BR /> <P></P><P></P><P></P></BODY></HTML> Wed, 01 Dec 2010 04:54:12 GMT 2010-12-01T04:54:12Z Problem using Fractile with Set Analysis https://community.qlik.com/t5/QlikView/Problem-using-Fractile-with-Set-Analysis/m-p/207592#M63293 <HTML><HEAD></HEAD><BODY><P>Hello,<BR /><BR />I have created an expression using fractile that returns a value of 5% for physicians. When comparing all physicians, the correct value is returned. However, when I select one or more physicians from a list, my return value changes. Can anyone tell me what I need to add to my script so that the value stays static (meaning it will ignore any selections I make from a list of physicians.<BR /><BR />fractile(aggr(count({&lt;IBEX_DISPOSITION_ATN_NAME=, RETURN_QUALIFIER={'1'}&gt;}IBEX_NUM) / (count({&lt;IBEX_DISPOSITION_ATN_NAME=, RETURN_QUALIFIER={'1'}&gt;}IBEX_NUM) + count({&lt;IBEX_DISPOSITION_ATN_NAME=, RETURN_QUALIFIER={'0'}&gt;}IBEX_NUM)),IBEX_DISPOSITION_ATN_LOGIN_ID),0.05)<BR /><BR />Thanks!!<BR /><BR />Scott<BR /><BR /></P><P></P><P></P><P></P><P></P><P></P><BR /><BR /> <P></P><P></P><P></P></BODY></HTML> Wed, 01 Dec 2010 04:54:12 GMT https://community.qlik.com/t5/QlikView/Problem-using-Fractile-with-Set-Analysis/m-p/207592#M63293 2010-12-01T04:54:12Z