Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

time interval between 2 columns

Hi, how do i find the time interval between 2 columns, datecreated and dateconfirmed, and extract the minutes? Thanks.

1 Solution

Accepted Solutions
MayilVahanan

Hi

Try like this

Edit:

Interval(DateConfirmed - DateCreated , 'mm')

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

6 Replies
MayilVahanan

Hi

Try like this

Edit:

Interval(DateConfirmed - DateCreated , 'mm')

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
hic
Former Employee
Former Employee

The following expression will give a correct numeric value:

     (dateconfirmed - datecreated) * 24 *60


An alternative is to keep the difference in days (an hour is then 1/24), but format it in minutes:

     Interval(datecreated-dateconfirmed,'mm')

Note that the format code is case sensitive.


HIC

Not applicable
Author

Hi,

if the two columns, datecreated and dateconfirmed are already formatted as timestamps, you can add the following expression:

time(num(datecreated)-num(dateconfirmed),'mm')

ThornOfCrowns
Specialist II
Specialist II

'MM' will give a month interval, 'mm' will give minute interval.

MayilVahanan

Hi James

Thanks for your reply. I didn't notice that.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
jonathandienst
Partner - Champion III
Partner - Champion III

Hi

Time() is quite different to Interval(). Time(value, 'mm') will format to display the minute number of the current time, while Interval(value, 'mm') will show the number of minutes in value.

     Eg.

          Time(1.55, 'mm') displays 12 (for a time of day of 13:12:00)

          Interval(1.55, 'mm') displays 2232 (number of minutes in 1.55 days)

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein