topic Expression for Counting Certain Days in QlikView https://community.qlik.com/t5/QlikView/Expression-for-Counting-Certain-Days/m-p/624585#M681574 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P></P><P>I have a requirement in which i have&nbsp;&nbsp;&nbsp; <STRONG>Order Number</STRONG>,<STRONG>Order Date</STRONG>,<STRONG>Delivery Date</STRONG> and<STRONG> Department</STRONG></P><P>Suppose i Received 100 Orders on the Date 25-03-2014 and have different delivery dates&nbsp; 27-03-2014,28-03-2014...........31-03-2014</P><P>Each day i may deliver different number of orders ,like on 27-03-14 i delivered 30 orders,next day i delivered 10 orders and so on ....</P><P>on 31-03-2014 I may deliver 5 orders. So my 100 orders were Completed and i delivered all and Achieved 100%. But i want to know </P><P>How Many Days it took me to achieve 95% i.e on which day i completed or the number of Days took me to deliver 95 orders.</P><P></P><P>So how can i do this .</P><P></P><P></P><P>I have attached the Sample Data and Applications. </P><P></P><P>Thanks in Advance.</P><P></P><P>Nikitha Jain M.B</P></BODY></HTML> Wed, 26 Mar 2014 11:07:30 GMT 2014-03-26T11:07:30Z Expression for Counting Certain Days https://community.qlik.com/t5/QlikView/Expression-for-Counting-Certain-Days/m-p/624585#M681574 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P></P><P>I have a requirement in which i have&nbsp;&nbsp;&nbsp; <STRONG>Order Number</STRONG>,<STRONG>Order Date</STRONG>,<STRONG>Delivery Date</STRONG> and<STRONG> Department</STRONG></P><P>Suppose i Received 100 Orders on the Date 25-03-2014 and have different delivery dates&nbsp; 27-03-2014,28-03-2014...........31-03-2014</P><P>Each day i may deliver different number of orders ,like on 27-03-14 i delivered 30 orders,next day i delivered 10 orders and so on ....</P><P>on 31-03-2014 I may deliver 5 orders. So my 100 orders were Completed and i delivered all and Achieved 100%. But i want to know </P><P>How Many Days it took me to achieve 95% i.e on which day i completed or the number of Days took me to deliver 95 orders.</P><P></P><P>So how can i do this .</P><P></P><P></P><P>I have attached the Sample Data and Applications. </P><P></P><P>Thanks in Advance.</P><P></P><P>Nikitha Jain M.B</P></BODY></HTML> Wed, 26 Mar 2014 11:07:30 GMT https://community.qlik.com/t5/QlikView/Expression-for-Counting-Certain-Days/m-p/624585#M681574 2014-03-26T11:07:30Z Re: Expression for Counting Certain Days https://community.qlik.com/t5/QlikView/Expression-for-Counting-Certain-Days/m-p/624586#M681575 <HTML><HEAD></HEAD><BODY><P>You probably need a Pareto Chart, see here: <A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/12/09/pareto-analysis">http://community.qlik.com/blogs/qlikviewdesignblog/2013/12/09/pareto-analysis</A> for details.</P></BODY></HTML> Wed, 26 Mar 2014 11:54:36 GMT https://community.qlik.com/t5/QlikView/Expression-for-Counting-Certain-Days/m-p/624586#M681575 ThornOfCrowns 2014-03-26T11:54:36Z Re: Expression for Counting Certain Days https://community.qlik.com/t5/QlikView/Expression-for-Counting-Certain-Days/m-p/624587#M681576 <HTML><HEAD></HEAD><BODY><P>hi thanks for ur reply,</P><P></P><P></P><P></P><P>but i need the <STRONG>NUMBER OF DAYS TAKEN</STRONG> TO ACHIEVE 95% OF ORDERS.</P></BODY></HTML> Wed, 26 Mar 2014 12:58:30 GMT https://community.qlik.com/t5/QlikView/Expression-for-Counting-Certain-Days/m-p/624587#M681576 2014-03-26T12:58:30Z Re: Expression for Counting Certain Days https://community.qlik.com/t5/QlikView/Expression-for-Counting-Certain-Days/m-p/624588#M681577 <HTML><HEAD></HEAD><BODY><P>See attached qvw.</P></BODY></HTML> Wed, 26 Mar 2014 13:04:14 GMT https://community.qlik.com/t5/QlikView/Expression-for-Counting-Certain-Days/m-p/624588#M681577 Gysbert_Wassenaar 2014-03-26T13:04:14Z