topic Re: How to convert sec to interval? in QlikView https://community.qlik.com/t5/QlikView/How-to-convert-sec-to-interval/m-p/1430461#M430356 <HTML><HEAD></HEAD><BODY><P>I guess it's because how qlik is handling the long numbers. It seems that number bigger than <STRONG>2147483648 (which is 2^31)</STRONG> are being interpreted differently (may be <EM>signed bit</EM> interpretation). So the discrepancy.</P></BODY></HTML> Tue, 21 Nov 2017 07:44:20 GMT tresB 2017-11-21T07:44:20Z How to convert sec to interval? https://community.qlik.com/t5/QlikView/How-to-convert-sec-to-interval/m-p/1430455#M430350 <HTML><HEAD></HEAD><BODY><P>Hi Expert,</P><P></P><P>In my data, time is available in seconds which should be shown in hh:mm:ss format.</P><P></P><P>I have tried using interval function but it is showing wrong result, can anyone help me on this?</P><P></P><P>Attached qvw file for reference.</P><P></P><P>Thanks,</P><P>Raju</P></BODY></HTML> Tue, 21 Nov 2017 06:58:41 GMT https://community.qlik.com/t5/QlikView/How-to-convert-sec-to-interval/m-p/1430455#M430350 raju_salmon 2017-11-21T06:58:41Z Re: How to convert sec to interval? https://community.qlik.com/t5/QlikView/How-to-convert-sec-to-interval/m-p/1430456#M430351 <HTML><HEAD></HEAD><BODY><P>Interval(SUM([Available Time in Sec]<STRONG>/24/60/60</STRONG>),'hh:mm:ss') </P></BODY></HTML> Tue, 21 Nov 2017 07:04:12 GMT https://community.qlik.com/t5/QlikView/How-to-convert-sec-to-interval/m-p/1430456#M430351 tresB 2017-11-21T07:04:12Z Re: How to convert sec to interval? https://community.qlik.com/t5/QlikView/How-to-convert-sec-to-interval/m-p/1430457#M430352 <HTML><HEAD></HEAD><BODY><P>Perfect...Thanks a lot Tresesco.</P></BODY></HTML> Tue, 21 Nov 2017 07:06:59 GMT https://community.qlik.com/t5/QlikView/How-to-convert-sec-to-interval/m-p/1430457#M430352 raju_salmon 2017-11-21T07:06:59Z Re: How to convert sec to interval? https://community.qlik.com/t5/QlikView/How-to-convert-sec-to-interval/m-p/1430458#M430353 <HTML><HEAD></HEAD><BODY><P>Is there any specific reason why my expression showing wrong result for 2014,2015 and 2016... but not for 2017?</P></BODY></HTML> Tue, 21 Nov 2017 07:08:29 GMT https://community.qlik.com/t5/QlikView/How-to-convert-sec-to-interval/m-p/1430458#M430353 raju_salmon 2017-11-21T07:08:29Z Re: How to convert sec to interval? https://community.qlik.com/t5/QlikView/How-to-convert-sec-to-interval/m-p/1430459#M430354 <HTML><HEAD></HEAD><BODY><P>Is not this what you see?</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/183990_Capture.JPG" style="height: 130px; width: 620px;" /></P></BODY></HTML> Tue, 21 Nov 2017 07:25:22 GMT https://community.qlik.com/t5/QlikView/How-to-convert-sec-to-interval/m-p/1430459#M430354 tresB 2017-11-21T07:25:22Z Re: How to convert sec to interval? https://community.qlik.com/t5/QlikView/How-to-convert-sec-to-interval/m-p/1430460#M430355 <HTML><HEAD></HEAD><BODY><P>If i use the expression which you suggested is working very fine and giving accurate result.</P><P></P><P>Earlier i tried with below expression, but not sure why it is not working.</P><P></P><P>Interval((Interval#((Num(SUM([Available Time in Sec]))),'SS')),'hh:mm:ss') </P></BODY></HTML> Tue, 21 Nov 2017 07:28:26 GMT https://community.qlik.com/t5/QlikView/How-to-convert-sec-to-interval/m-p/1430460#M430355 raju_salmon 2017-11-21T07:28:26Z Re: How to convert sec to interval? https://community.qlik.com/t5/QlikView/How-to-convert-sec-to-interval/m-p/1430461#M430356 <HTML><HEAD></HEAD><BODY><P>I guess it's because how qlik is handling the long numbers. It seems that number bigger than <STRONG>2147483648 (which is 2^31)</STRONG> are being interpreted differently (may be <EM>signed bit</EM> interpretation). So the discrepancy.</P></BODY></HTML> Tue, 21 Nov 2017 07:44:20 GMT https://community.qlik.com/t5/QlikView/How-to-convert-sec-to-interval/m-p/1430461#M430356 tresB 2017-11-21T07:44:20Z