topic Re: Exclude Selection using set in QlikView https://community.qlik.com/t5/QlikView/Exclude-Selection-using-set/m-p/330692#M121776 <HTML><HEAD></HEAD><BODY><P>HI Sivaraj,</P><P></P><P>Try this code</P><P></P><P>Avg({$&lt;A=,B=&gt;}if(D ='Service' and C &gt; aggr(NODISTINCT fractile(C, 0.05), A) and C&lt; aggr(NODISTINCT fractile(C, 0.95), A),C))</P><P></P><P></P><P>Deepak</P></BODY></HTML> Tue, 03 Jul 2012 07:39:07 GMT deepakk 2012-07-03T07:39:07Z Exclude Selection using set https://community.qlik.com/t5/QlikView/Exclude-Selection-using-set/m-p/330691#M121775 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am using set to exclude some fields selection but its not working. My expression is like</P><P>Avg({$&lt;A,B&gt;}if(D ='Service' and C &gt; aggr(NODISTINCT fractile(C, 0.05), A) and C&lt; aggr(NODISTINCT fractile(C, 0.95), A),C))</P><P>I f i select A its getting changed</P><P></P><P>Regards,</P><P>Sivaraj</P></BODY></HTML> Tue, 03 Jul 2012 07:23:35 GMT https://community.qlik.com/t5/QlikView/Exclude-Selection-using-set/m-p/330691#M121775 sivarajs 2012-07-03T07:23:35Z Re: Exclude Selection using set https://community.qlik.com/t5/QlikView/Exclude-Selection-using-set/m-p/330692#M121776 <HTML><HEAD></HEAD><BODY><P>HI Sivaraj,</P><P></P><P>Try this code</P><P></P><P>Avg({$&lt;A=,B=&gt;}if(D ='Service' and C &gt; aggr(NODISTINCT fractile(C, 0.05), A) and C&lt; aggr(NODISTINCT fractile(C, 0.95), A),C))</P><P></P><P></P><P>Deepak</P></BODY></HTML> Tue, 03 Jul 2012 07:39:07 GMT https://community.qlik.com/t5/QlikView/Exclude-Selection-using-set/m-p/330692#M121776 deepakk 2012-07-03T07:39:07Z Re: Exclude Selection using set https://community.qlik.com/t5/QlikView/Exclude-Selection-using-set/m-p/330693#M121777 <HTML><HEAD></HEAD><BODY><P>i have already tried that but it didn't work</P></BODY></HTML> Tue, 03 Jul 2012 07:43:21 GMT https://community.qlik.com/t5/QlikView/Exclude-Selection-using-set/m-p/330693#M121777 sivarajs 2012-07-03T07:43:21Z