topic Re: How to convert seconds into number in QlikView https://community.qlik.com/t5/QlikView/How-to-convert-seconds-into-number/m-p/694893#M251232 <HTML><HEAD></HEAD><BODY><P> got it ans Num#(Text(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Interval(LOAD_STATUS_DT-INSERT_DT ,'ss')</SPAN>))</P></BODY></HTML> Thu, 25 Sep 2014 12:48:08 GMT 2014-09-25T12:48:08Z How to convert seconds into number https://community.qlik.com/t5/QlikView/How-to-convert-seconds-into-number/m-p/694892#M251231 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am using interval function to find the difference between two time stamps in seconds like(Interval(LOAD_STATUS_DT-INSERT_DT ,'ss') .But when i am calculating its still considers as time but i need in number to calculate the average.</P><P></P><P>Example :- i using above formula in scripts now i have two columns 1.No of records,2.Exec time in sec </P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 3</STRONG></TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">10000</TD><TD style="padding: 2px;">94</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">200000</TD><TD style="padding: 2px;">98</TD></TR></TBODY></TABLE><P></P><P>In expression =Sum(Header2)/Sum(Header3).It suppose to take&nbsp; 210000)/104 </P><P>but it is actually doing 210000/0.02.58 Am</P><P></P><P>Could you please help me how to calculate average .</P><P></P><P>Thanks,</P><P>Rahul </P></BODY></HTML> Thu, 25 Sep 2014 12:30:05 GMT https://community.qlik.com/t5/QlikView/How-to-convert-seconds-into-number/m-p/694892#M251231 2014-09-25T12:30:05Z Re: How to convert seconds into number https://community.qlik.com/t5/QlikView/How-to-convert-seconds-into-number/m-p/694893#M251232 <HTML><HEAD></HEAD><BODY><P> got it ans Num#(Text(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Interval(LOAD_STATUS_DT-INSERT_DT ,'ss')</SPAN>))</P></BODY></HTML> Thu, 25 Sep 2014 12:48:08 GMT https://community.qlik.com/t5/QlikView/How-to-convert-seconds-into-number/m-p/694893#M251232 2014-09-25T12:48:08Z