topic Re: How to calculate Days in Order? in QlikView https://community.qlik.com/t5/QlikView/How-to-calculate-Days-in-Order/m-p/693431#M1056126 <HTML><HEAD></HEAD><BODY><P>Can you explain your requirement with example and expected output</P></BODY></HTML> Thu, 09 Oct 2014 14:07:21 GMT anbu1984 2014-10-09T14:07:21Z How to calculate Days in Order? https://community.qlik.com/t5/QlikView/How-to-calculate-Days-in-Order/m-p/693430#M1056125 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>can anyone suggest me please how can I calculate 'Days in Order' based on 'DateEnter'</P><P></P><P>I have a filed in table box 'DateEnter'&nbsp; by using this filed I have to calculate 'Days in Order'</P><P></P><P>The 'DateEnter' field have values from 201 to current day.</P><P></P><P>Thanks.</P></BODY></HTML> Thu, 09 Oct 2014 14:06:02 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-Days-in-Order/m-p/693430#M1056125 2014-10-09T14:06:02Z Re: How to calculate Days in Order? https://community.qlik.com/t5/QlikView/How-to-calculate-Days-in-Order/m-p/693431#M1056126 <HTML><HEAD></HEAD><BODY><P>Can you explain your requirement with example and expected output</P></BODY></HTML> Thu, 09 Oct 2014 14:07:21 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-Days-in-Order/m-p/693431#M1056126 anbu1984 2014-10-09T14:07:21Z Re: How to calculate Days in Order? https://community.qlik.com/t5/QlikView/How-to-calculate-Days-in-Order/m-p/693432#M1056127 <HTML><HEAD></HEAD><BODY><P>Thanks.</P><P></P><P>I have ID= 43242 sample DateEnter=20/08/2010 based on this date I need to calculate Days in Order</P><P></P><P>expected output</P><P></P><P>ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Days in Order</P><P>674671&nbsp;&nbsp; 1118.98</P><P>76746&nbsp;&nbsp;&nbsp;&nbsp; 1118.98</P><P>67467&nbsp;&nbsp;&nbsp;&nbsp; 1118.98</P></BODY></HTML> Thu, 09 Oct 2014 14:46:06 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-Days-in-Order/m-p/693432#M1056127 2014-10-09T14:46:06Z Re: How to calculate Days in Order? https://community.qlik.com/t5/QlikView/How-to-calculate-Days-in-Order/m-p/693433#M1056128 <HTML><HEAD></HEAD><BODY><P>Is 'Days in Order'&nbsp; the number of days between today and the value of 'DateEnter' ? </P><P></P><P>If that is the case you do this to give you the number of days:</P><P></P><P>date(today()) - date(DateEnter)</P></BODY></HTML> Thu, 09 Oct 2014 16:47:37 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-Days-in-Order/m-p/693433#M1056128 JonnyPoole 2014-10-09T16:47:37Z