topic Re: ExpressionHelp in QlikView https://community.qlik.com/t5/QlikView/ExpressionHelp/m-p/950637#M967930 <HTML><HEAD></HEAD><BODY><P>Try interval(Field1-Field2, 's')</P></BODY></HTML> Mon, 28 Sep 2015 13:30:33 GMT Gysbert_Wassenaar 2015-09-28T13:30:33Z ExpressionHelp https://community.qlik.com/t5/QlikView/ExpressionHelp/m-p/950636#M967929 <HTML><HEAD></HEAD><BODY><P>Hey Guys,</P><P></P><P>I have one Field in which i am getting Value in Below Format</P><P></P><P>Field1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Field2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Output(Wants in Second)</P><P></P><P>28-09-15 04:46:52 PM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">28-09-15 01:15:20 </SPAN> PM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3:31:31 PM&nbsp; (How i can convert it into seconds)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P>Please Suggest</P><P></P><P>Thanks</P><P></P><P>Abhay</P></BODY></HTML> Mon, 28 Sep 2015 13:25:29 GMT https://community.qlik.com/t5/QlikView/ExpressionHelp/m-p/950636#M967929 abhaysingh 2015-09-28T13:25:29Z Re: ExpressionHelp https://community.qlik.com/t5/QlikView/ExpressionHelp/m-p/950637#M967930 <HTML><HEAD></HEAD><BODY><P>Try interval(Field1-Field2, 's')</P></BODY></HTML> Mon, 28 Sep 2015 13:30:33 GMT https://community.qlik.com/t5/QlikView/ExpressionHelp/m-p/950637#M967930 Gysbert_Wassenaar 2015-09-28T13:30:33Z Re: ExpressionHelp https://community.qlik.com/t5/QlikView/ExpressionHelp/m-p/950638#M967931 <HTML><HEAD></HEAD><BODY><P>No change in data..still getting&nbsp; <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px;">3:31:31 PM</SPAN></P></BODY></HTML> Mon, 28 Sep 2015 13:33:07 GMT https://community.qlik.com/t5/QlikView/ExpressionHelp/m-p/950638#M967931 abhaysingh 2015-09-28T13:33:07Z Re: ExpressionHelp https://community.qlik.com/t5/QlikView/ExpressionHelp/m-p/950639#M967932 <HTML><HEAD></HEAD><BODY><P>Sory getting this number output</P><P></P><P>-15020907</P><P></P><P>thanks</P></BODY></HTML> Mon, 28 Sep 2015 13:34:32 GMT https://community.qlik.com/t5/QlikView/ExpressionHelp/m-p/950639#M967932 abhaysingh 2015-09-28T13:34:32Z Re: ExpressionHelp https://community.qlik.com/t5/QlikView/ExpressionHelp/m-p/950640#M967935 <HTML><HEAD></HEAD><BODY><P>This is a duplicate of <A href="https://community.qlik.com/thread/182924">Exp Help</A></P></BODY></HTML> Mon, 28 Sep 2015 13:37:08 GMT https://community.qlik.com/t5/QlikView/ExpressionHelp/m-p/950640#M967935 jonathandienst 2015-09-28T13:37:08Z Re: ExpressionHelp https://community.qlik.com/t5/QlikView/ExpressionHelp/m-p/950641#M967938 <HTML><HEAD></HEAD><BODY><P>is the time that is stored contain seconds?&nbsp; If seconds are not part of the field you will not be able to get accurate seconds (I do not believe)</P></BODY></HTML> Mon, 28 Sep 2015 13:48:33 GMT https://community.qlik.com/t5/QlikView/ExpressionHelp/m-p/950641#M967938 2015-09-28T13:48:33Z Re: ExpressionHelp https://community.qlik.com/t5/QlikView/ExpressionHelp/m-p/950642#M967940 <HTML><HEAD></HEAD><BODY><P>=Interval(Time#('10:43:36 AM', 'hh:mm:ss TT') - Time#('10:22:00 AM', 'hh:mm:ss TT'), 's')</P><P>to convert sec's as well as minuts and hours and days also by using interval function</P></BODY></HTML> Mon, 28 Sep 2015 17:43:14 GMT https://community.qlik.com/t5/QlikView/ExpressionHelp/m-p/950642#M967940 pratap6699 2015-09-28T17:43:14Z