topic Re: time interval between 2 columns in QlikView

time interval between 2 columns

Mon, 19 May 2014 09:49:28 GMT

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

Re: time interval between 2 columns

MayilVahanan — Mon, 19 May 2014 09:52:08 GMT

Try like this

Edit:

Interval(DateConfirmed - DateCreated , 'mm')

Re: time interval between 2 columns

hic — Mon, 19 May 2014 10:11:21 GMT

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

Re: time interval between 2 columns

Mon, 19 May 2014 10:19:39 GMT

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')

Re: time interval between 2 columns

ThornOfCrowns — Mon, 19 May 2014 10:21:26 GMT

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

Re: time interval between 2 columns

MayilVahanan — Mon, 19 May 2014 10:28:38 GMT

Hi James

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

Re: time interval between 2 columns

jonathandienst — Mon, 19 May 2014 11:04:19 GMT

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