topic Re: How to change Interval into NUM in QlikView https://community.qlik.com/t5/QlikView/How-to-change-Interval-into-NUM/m-p/519909#M194284 <HTML><HEAD></HEAD><BODY><P>hi</P><P>try this</P><P>num(date(datefieldintervalcalculation))</P></BODY></HTML> Thu, 16 Jan 2014 10:35:13 GMT 2014-01-16T10:35:13Z How to change Interval into NUM https://community.qlik.com/t5/QlikView/How-to-change-Interval-into-NUM/m-p/519908#M194283 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P>I am abstracting interval from starttime and endtime. but the format for the same is time format. i want to use it in a calculation but when i changes it to num problem arises.please help.</P><P></P><P></P><P></P><P>Regards,</P><P>piyush</P></BODY></HTML> Thu, 16 Jan 2014 10:24:51 GMT https://community.qlik.com/t5/QlikView/How-to-change-Interval-into-NUM/m-p/519908#M194283 2014-01-16T10:24:51Z Re: How to change Interval into NUM https://community.qlik.com/t5/QlikView/How-to-change-Interval-into-NUM/m-p/519909#M194284 <HTML><HEAD></HEAD><BODY><P>hi</P><P>try this</P><P>num(date(datefieldintervalcalculation))</P></BODY></HTML> Thu, 16 Jan 2014 10:35:13 GMT https://community.qlik.com/t5/QlikView/How-to-change-Interval-into-NUM/m-p/519909#M194284 2014-01-16T10:35:13Z Re: How to change Interval into NUM https://community.qlik.com/t5/QlikView/How-to-change-Interval-into-NUM/m-p/519910#M194285 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am using Interval([Stattime]-[Endtime]). please use above calculation on this. i didn't get it.</P><P></P><P>Regards,</P><P>Piyush</P></BODY></HTML> Thu, 16 Jan 2014 10:37:42 GMT https://community.qlik.com/t5/QlikView/How-to-change-Interval-into-NUM/m-p/519910#M194285 2014-01-16T10:37:42Z Re: How to change Interval into NUM https://community.qlik.com/t5/QlikView/How-to-change-Interval-into-NUM/m-p/519911#M194286 <HTML><HEAD></HEAD><BODY><P>Hi Try like this..</P><P></P><P>Interval(Date(StartDate,'DD/MM/YYYY') -Date(ENDDate,'DD/MM/YYYY') ,'D') it will give you number of days...</P><P></P><P>Thanks,</P><P>Selva</P></BODY></HTML> Thu, 16 Jan 2014 10:48:13 GMT https://community.qlik.com/t5/QlikView/How-to-change-Interval-into-NUM/m-p/519911#M194286 2014-01-16T10:48:13Z Re: How to change Interval into NUM https://community.qlik.com/t5/QlikView/How-to-change-Interval-into-NUM/m-p/519912#M194287 <HTML><HEAD></HEAD><BODY><P>hi</P><P>suppose your starttime and endtime in same date format.</P><P>then</P><P><SPAN class="Bold">num(interval( Stattime-Endtime, 'D hh:mm' ))</SPAN></P></BODY></HTML> Thu, 16 Jan 2014 10:55:46 GMT https://community.qlik.com/t5/QlikView/How-to-change-Interval-into-NUM/m-p/519912#M194287 2014-01-16T10:55:46Z Re: How to change Interval into NUM https://community.qlik.com/t5/QlikView/How-to-change-Interval-into-NUM/m-p/519913#M194288 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>We cannot use num before interval cos its format changes.but Got answer after trying.</P><P></P><P>Regards</P><P>Piyush.</P></BODY></HTML> Thu, 16 Jan 2014 12:46:34 GMT https://community.qlik.com/t5/QlikView/How-to-change-Interval-into-NUM/m-p/519913#M194288 2014-01-16T12:46:34Z Re: How to change Interval into NUM https://community.qlik.com/t5/QlikView/How-to-change-Interval-into-NUM/m-p/519914#M194289 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Got Answer. Thanks for ur valuable suggestion</P><P>Regards,</P><P>Piyush</P></BODY></HTML> Thu, 16 Jan 2014 12:47:22 GMT https://community.qlik.com/t5/QlikView/How-to-change-Interval-into-NUM/m-p/519914#M194289 2014-01-16T12:47:22Z Re: How to change Interval into NUM https://community.qlik.com/t5/QlikView/How-to-change-Interval-into-NUM/m-p/519915#M194290 <HTML><HEAD></HEAD><BODY><P>Mark Answer that is correct. It'll help community not to spend time for reading <SPAN style="color: #000000; font-family: arial, sans-serif; font-size: 13px;">idle</SPAN> posts.</P></BODY></HTML> Fri, 28 Apr 2017 13:27:27 GMT https://community.qlik.com/t5/QlikView/How-to-change-Interval-into-NUM/m-p/519915#M194290 stantrolav 2017-04-28T13:27:27Z