topic Re: How to convert Time into millisecond in QlikView https://community.qlik.com/t5/QlikView/How-to-convert-Time-into-millisecond/m-p/653832#M238958 <HTML><HEAD></HEAD><BODY><P>instead of Interval() if i use Timestamp() then also its working.. then what is different between these two...</P></BODY></HTML> Tue, 09 Sep 2014 10:25:20 GMT 2014-09-09T10:25:20Z How to convert Time into millisecond https://community.qlik.com/t5/QlikView/How-to-convert-Time-into-millisecond/m-p/653829#M238955 <HTML><HEAD></HEAD><BODY><P>Dear All, i want to know how to convert Time "00:00:00.000" to Millisecond. Ex : if time difference of two time 11:00:00.010 - 11:00:01.020 = 00:00:01.010. i want to show it as 1010 Please help</P></BODY></HTML> Tue, 09 Sep 2014 10:04:27 GMT https://community.qlik.com/t5/QlikView/How-to-convert-Time-into-millisecond/m-p/653829#M238955 2014-09-09T10:04:27Z Re: How to convert Time into millisecond https://community.qlik.com/t5/QlikView/How-to-convert-Time-into-millisecond/m-p/653830#M238956 <HTML><HEAD></HEAD><BODY><P>=Interval(Time#('11:00:01.020','hh:mm:ss.fff')-Time#('11:00:00.010','hh:mm:ss.fff'),'sfff')</P></BODY></HTML> Tue, 09 Sep 2014 10:10:04 GMT https://community.qlik.com/t5/QlikView/How-to-convert-Time-into-millisecond/m-p/653830#M238956 Gysbert_Wassenaar 2014-09-09T10:10:04Z Re: How to convert Time into millisecond https://community.qlik.com/t5/QlikView/How-to-convert-Time-into-millisecond/m-p/653831#M238957 <HTML><HEAD></HEAD><BODY><P>Thanks Gysbert</P></BODY></HTML> Tue, 09 Sep 2014 10:19:42 GMT https://community.qlik.com/t5/QlikView/How-to-convert-Time-into-millisecond/m-p/653831#M238957 2014-09-09T10:19:42Z Re: How to convert Time into millisecond https://community.qlik.com/t5/QlikView/How-to-convert-Time-into-millisecond/m-p/653832#M238958 <HTML><HEAD></HEAD><BODY><P>instead of Interval() if i use Timestamp() then also its working.. then what is different between these two...</P></BODY></HTML> Tue, 09 Sep 2014 10:25:20 GMT https://community.qlik.com/t5/QlikView/How-to-convert-Time-into-millisecond/m-p/653832#M238958 2014-09-09T10:25:20Z Re: How to convert Time into millisecond https://community.qlik.com/t5/QlikView/How-to-convert-Time-into-millisecond/m-p/653833#M238959 <HTML><HEAD></HEAD><BODY><P>The difference is that timestamp is a point in time, not an duration between two points in time. You can see this if you make a timestamp out of 26 hours. Try these two in text boxes:</P><P>=interval(26/24,'hh')</P><P>=timestamp(26/24,'hh')</P></BODY></HTML> Tue, 09 Sep 2014 10:42:49 GMT https://community.qlik.com/t5/QlikView/How-to-convert-Time-into-millisecond/m-p/653833#M238959 Gysbert_Wassenaar 2014-09-09T10:42:49Z Re: How to convert Time into millisecond https://community.qlik.com/t5/QlikView/How-to-convert-Time-into-millisecond/m-p/653834#M238960 <HTML><HEAD></HEAD><BODY><P>For sorting purposses you might also wish to try the expression:</P><P></P><P style="font-weight: inherit; font-style: inherit; font-size: 17px; font-family: inherit;">=(Time#('11:00:01.020','hh:mm:ss.fff')-Time#('11:00:00.010','hh:mm:ss.fff'))*86400000</P><P style="font-weight: inherit; font-style: inherit; font-size: 17px; font-family: inherit;"></P><P style="font-weight: inherit; font-style: inherit; font-size: 17px; font-family: inherit;">Hope this helps</P><P style="font-weight: inherit; font-style: inherit; font-size: 17px; font-family: inherit;">Regards</P><P style="font-weight: inherit; font-style: inherit; font-size: 17px; font-family: inherit;">Marco</P></BODY></HTML> Wed, 10 Sep 2014 05:40:28 GMT https://community.qlik.com/t5/QlikView/How-to-convert-Time-into-millisecond/m-p/653834#M238960 MarcoWedel 2014-09-10T05:40:28Z Re: How to convert Time into millisecond https://community.qlik.com/t5/QlikView/How-to-convert-Time-into-millisecond/m-p/653835#M238961 <HTML><HEAD></HEAD><BODY><P>Thanks <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Wed, 10 Sep 2014 09:20:06 GMT https://community.qlik.com/t5/QlikView/How-to-convert-Time-into-millisecond/m-p/653835#M238961 2014-09-10T09:20:06Z Re: How to convert Time into millisecond https://community.qlik.com/t5/QlikView/How-to-convert-Time-into-millisecond/m-p/653836#M238962 <HTML><HEAD></HEAD><BODY><P>You're welcome.</P><P>Regards</P><P>Marco</P></BODY></HTML> Wed, 10 Sep 2014 09:58:56 GMT https://community.qlik.com/t5/QlikView/How-to-convert-Time-into-millisecond/m-p/653836#M238962 MarcoWedel 2014-09-10T09:58:56Z Re: Re: How to convert Time into millisecond https://community.qlik.com/t5/QlikView/How-to-convert-Time-into-millisecond/m-p/653837#M238963 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I noticed some effects due to the limited resolution of real values, so the result has to be converted to an integer:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="_jivemacro_uid_14103448089239073 jive_text_macro jive_macro_code" jivemacro_uid="_14103448089239073"> <P>=Round((Time#('11:00:01.020','hh:mm:ss.fff')-Time#('11:00:00.010','hh:mm:ss.fff'))*86400000)</P> </PRE><P></P><P><IMG __jive_id="66458" alt="QlikCommunity_Thread_132xxx_Pic1.JPG.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/66458_QlikCommunity_Thread_132xxx_Pic1.JPG.jpg" /></P><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Wed, 10 Sep 2014 10:25:52 GMT https://community.qlik.com/t5/QlikView/How-to-convert-Time-into-millisecond/m-p/653837#M238963 MarcoWedel 2014-09-10T10:25:52Z