topic Re: Calculating closure status in QlikView https://community.qlik.com/t5/QlikView/Calculating-closure-status/m-p/1054568#M937995 <HTML><HEAD></HEAD><BODY><P>Please post a small qlikview document that illustrates the problem.</P></BODY></HTML> Fri, 05 Feb 2016 17:23:35 GMT Gysbert_Wassenaar 2016-02-05T17:23:35Z Calculating closure status https://community.qlik.com/t5/QlikView/Calculating-closure-status/m-p/1054567#M937994 <HTML><HEAD></HEAD><BODY><P>To find the&nbsp; Same day closure status of a ticket i am comparing created date and closed date and&nbsp; the code is as follows:</P><P></P><TABLE><TBODY><TR><TD>if(num(makedate(year(Created),month(Created),day(Created)))=num(makedate(year(Closed),month(Closed),day(Closed))), 'Yes','No') as _SameDayClosure</TD><TD></TD></TR></TBODY></TABLE><P></P><P>So if a ticket is logged at 4 pm and it is closed within midnight same day closure will be yes.</P><P>In my scenario i want to find whether the ticket is closed within 24 hrs so how can i do the calculation i.e if we consider the same ticket logged at 4.00 pm ,it is closed at next day 4.00 pm and&nbsp; i want to make the status as yes.can anyone help?</P></BODY></HTML> Fri, 05 Feb 2016 05:40:38 GMT https://community.qlik.com/t5/QlikView/Calculating-closure-status/m-p/1054567#M937994 2016-02-05T05:40:38Z Re: Calculating closure status https://community.qlik.com/t5/QlikView/Calculating-closure-status/m-p/1054568#M937995 <HTML><HEAD></HEAD><BODY><P>Please post a small qlikview document that illustrates the problem.</P></BODY></HTML> Fri, 05 Feb 2016 17:23:35 GMT https://community.qlik.com/t5/QlikView/Calculating-closure-status/m-p/1054568#M937995 Gysbert_Wassenaar 2016-02-05T17:23:35Z Re: Calculating closure status https://community.qlik.com/t5/QlikView/Calculating-closure-status/m-p/1054569#M937996 <HTML><HEAD></HEAD><BODY><P>If(Closed-Created &lt;= 1 and Closed-Created &gt;= 0, 'Yes','No') as _24hrsClosure</P></BODY></HTML> Fri, 05 Feb 2016 17:32:37 GMT https://community.qlik.com/t5/QlikView/Calculating-closure-status/m-p/1054569#M937996 MarcoWedel 2016-02-05T17:32:37Z