topic Time duration in IF statement in App Development https://community.qlik.com/t5/App-Development/Time-duration-in-IF-statement/m-p/1101147#M18610 <HTML><HEAD></HEAD><BODY><P>I am trying to create an IF statement in my load script that will identify whether a duration between two timestamps exceeded 45 minutes.</P><P></P><P>What I have tried is:</P><P></P><P>(resolved_at - "Opened time") * 24 as 'duration',</P><P>If('duration' &lt;= 0.75, 'Met', 'Not Met') as 'SLA',</P><P></P><P>I have created a table and 'duration' correctly gives the number of hours (in decimal format) between the two timestamps. However, every entry has 'Not Met' in the 'SLA' field.</P><P></P><P>Clearly there is something incorrect with my number formatting. Any help would be greatly appreciated.</P><P></P><P>Conor</P></BODY></HTML> Sat, 16 Nov 2024 10:27:43 GMT 2024-11-16T10:27:43Z Time duration in IF statement https://community.qlik.com/t5/App-Development/Time-duration-in-IF-statement/m-p/1101147#M18610 <HTML><HEAD></HEAD><BODY><P>I am trying to create an IF statement in my load script that will identify whether a duration between two timestamps exceeded 45 minutes.</P><P></P><P>What I have tried is:</P><P></P><P>(resolved_at - "Opened time") * 24 as 'duration',</P><P>If('duration' &lt;= 0.75, 'Met', 'Not Met') as 'SLA',</P><P></P><P>I have created a table and 'duration' correctly gives the number of hours (in decimal format) between the two timestamps. However, every entry has 'Not Met' in the 'SLA' field.</P><P></P><P>Clearly there is something incorrect with my number formatting. Any help would be greatly appreciated.</P><P></P><P>Conor</P></BODY></HTML> Sat, 16 Nov 2024 10:27:43 GMT https://community.qlik.com/t5/App-Development/Time-duration-in-IF-statement/m-p/1101147#M18610 2024-11-16T10:27:43Z Re: Time duration in IF statement https://community.qlik.com/t5/App-Development/Time-duration-in-IF-statement/m-p/1101148#M18611 <HTML><HEAD></HEAD><BODY><P>Can you check this:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>(resolved_at - "Opened time") as duration,</STRONG></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>If(duration &lt;= MakeTime(0, 45), 'Met', 'Not Met') as SLA</STRONG></SPAN></P></BODY></HTML> Fri, 12 Aug 2016 14:18:18 GMT https://community.qlik.com/t5/App-Development/Time-duration-in-IF-statement/m-p/1101148#M18611 sunny_talwar 2016-08-12T14:18:18Z