topic Re: Turn around Time in QlikView https://community.qlik.com/t5/QlikView/Turn-around-Time/m-p/626098#M230213 <HTML><HEAD></HEAD><BODY><P>In your attached xls file above, add one more column stating your expected output and re-attach here.</P></BODY></HTML> Wed, 12 Mar 2014 07:38:39 GMT tresB 2014-03-12T07:38:39Z Turn around Time https://community.qlik.com/t5/QlikView/Turn-around-Time/m-p/626095#M230210 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am facing an issue here, I have the following set of data which I have attached below. All I need to find is the time interval between the different S_Status Field for each T_Name:</P></BODY></HTML> Wed, 12 Mar 2014 06:29:03 GMT https://community.qlik.com/t5/QlikView/Turn-around-Time/m-p/626095#M230210 2014-03-12T06:29:03Z Re: Turn around Time https://community.qlik.com/t5/QlikView/Turn-around-Time/m-p/626096#M230211 <HTML><HEAD></HEAD><BODY><P>Try to create an additional column in the dummy set to tell expected output.</P></BODY></HTML> Wed, 12 Mar 2014 07:01:14 GMT https://community.qlik.com/t5/QlikView/Turn-around-Time/m-p/626096#M230211 tresB 2014-03-12T07:01:14Z Re: Turn around Time https://community.qlik.com/t5/QlikView/Turn-around-Time/m-p/626097#M230212 <HTML><HEAD></HEAD><BODY><P>I created a new field named "Time_2" and used the following query in Text Object:</P><P></P><P>=Interval(if(S_Status='F',Time) - if(S_Status='D',RT_Time_Field_2),'hh:mm:ss')</P><P></P><P>This did not work.</P></BODY></HTML> Wed, 12 Mar 2014 07:20:31 GMT https://community.qlik.com/t5/QlikView/Turn-around-Time/m-p/626097#M230212 2014-03-12T07:20:31Z Re: Turn around Time https://community.qlik.com/t5/QlikView/Turn-around-Time/m-p/626098#M230213 <HTML><HEAD></HEAD><BODY><P>In your attached xls file above, add one more column stating your expected output and re-attach here.</P></BODY></HTML> Wed, 12 Mar 2014 07:38:39 GMT https://community.qlik.com/t5/QlikView/Turn-around-Time/m-p/626098#M230213 tresB 2014-03-12T07:38:39Z Re: Re: Turn around Time https://community.qlik.com/t5/QlikView/Turn-around-Time/m-p/626099#M230214 <HTML><HEAD></HEAD><BODY><P>Please find the new excel sheet with the expected o/p.</P></BODY></HTML> Wed, 12 Mar 2014 07:56:46 GMT https://community.qlik.com/t5/QlikView/Turn-around-Time/m-p/626099#M230214 2014-03-12T07:56:46Z