topic Re: Clipping data in QlikView https://community.qlik.com/t5/QlikView/Clipping-data/m-p/377278#M495156 <HTML><HEAD></HEAD><BODY><P>Check the attached file</P></BODY></HTML> Mon, 13 Aug 2012 10:34:44 GMT sivarajs 2012-08-13T10:34:44Z Clipping data https://community.qlik.com/t5/QlikView/Clipping-data/m-p/377277#M495155 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I have to exclude extremely low values from calculations. I would like to do it on fly, in the expressions, not in the load script though.&nbsp; </P><P>Please have a look at the example attached. I have calls list with relevant ID, caller and value. I would like to count the number of calls by caller ignoring the first 10% of the calls of each caller that have low values. </P><P>I’m able to get it work when I have one caller selected. As you can see caller Frieals has 40 calls in total and when it’s been selected I get 36 calls (4 calls have been clipped out).</P><P>How to make it work overall, for all callers is still problem for me. Any ideas and suggestions are welcome and much appretiated.</P><P>Thanks</P><P>Y</P></BODY></HTML> Mon, 13 Aug 2012 09:47:51 GMT https://community.qlik.com/t5/QlikView/Clipping-data/m-p/377277#M495155 yavoro 2012-08-13T09:47:51Z Re: Clipping data https://community.qlik.com/t5/QlikView/Clipping-data/m-p/377278#M495156 <HTML><HEAD></HEAD><BODY><P>Check the attached file</P></BODY></HTML> Mon, 13 Aug 2012 10:34:44 GMT https://community.qlik.com/t5/QlikView/Clipping-data/m-p/377278#M495156 sivarajs 2012-08-13T10:34:44Z Re: Clipping data https://community.qlik.com/t5/QlikView/Clipping-data/m-p/377279#M495157 <HTML><HEAD></HEAD><BODY><P>Nice and simple, seems to be working as wanted. Will have to play with it further.</P><P>Thanks</P></BODY></HTML> Mon, 13 Aug 2012 10:58:59 GMT https://community.qlik.com/t5/QlikView/Clipping-data/m-p/377279#M495157 yavoro 2012-08-13T10:58:59Z