topic Re: Script to subtract time between 2 columns in QlikView

Script to subtract time between 2 columns

Thu, 15 May 2014 07:05:36 GMT

Hi, how do I find the difference in time between 2 columns 'Date Created' and 'Date Confirmed' and display the difference in mins? Thanks.

Re: Script to subtract time between 2 columns

ashfaq_haseeb — Thu, 15 May 2014 07:11:14 GMT

Hi,

Try below

Interval( Date('2010-11-19 09:22:09.000') - Date( '2010-11-19 11:52:38.000'), 'hh:mm:ss')

Interval( Date('19:43') - Date( '12:56'), 'hh:mm:ss')

If you need in minute then try below.

time(frac(date2) - frac(date1))

Regards

ASHFAQ

Re: Script to subtract time between 2 columns

Anonymous — Thu, 15 May 2014 07:12:00 GMT

Try this:

Timestamp#(Timestamp#([Fieldname1])-Timestamp#([Fieldname2]))

Re: Script to subtract time between 2 columns

nlmmaurya — Thu, 15 May 2014 07:12:35 GMT

Hi,

Try this:

Interval(([Date Confirmed]- [Date Created]),'mm:ss')

Regards,

Neelam

Re: Script to subtract time between 2 columns

crusader_ — Thu, 15 May 2014 07:20:42 GMT

Hi,

Try this one:

Interval([Date Confirmed]-[Date Created])

HTH

Andrei

Re: Script to subtract time between 2 columns

Thu, 15 May 2014 07:23:35 GMT

I cannot use specific time as I want to find the time difference for all the times between the 2 mentioned fields. Thanks.

Re: Script to subtract time between 2 columns

Thu, 15 May 2014 07:26:54 GMT

Thanks, but I got negative minutes until a thousand over for example '-1034'

Re: Script to subtract time between 2 columns

Thu, 15 May 2014 07:34:36 GMT

Thanks, but why do I have negative timings now.

Re: Script to subtract time between 2 columns

crusader_ — Thu, 15 May 2014 07:37:41 GMT

Are you sure that [Date Created] less than [Date Confirmed] ?

Cause you shouldn't get negative results

Andrei

Re: Script to subtract time between 2 columns

Thu, 15 May 2014 07:39:15 GMT

Hi Rachel,

Can you attach a sample of your data, as in one of my apps I use the below and i have accurate results:

num#(Interval(SESSION_DATEFIN - SESSION_DATEDEB, 'ss')) / 3600 as TimeInHr,

num#(Interval(SESSION_DATEFIN - SESSION_DATEDEB, 'ss')) / 60 as TimeInMin,

num#(Interval(SESSION_DATEFIN - SESSION_DATEDEB, 'ss')) as TimeInSec

Re: Script to subtract time between 2 columns

Thu, 15 May 2014 07:51:35 GMT

Yes, Date created is less than Date Confirmed.

Re: Script to subtract time between 2 columns

crusader_ — Thu, 15 May 2014 08:21:28 GMT

Can you attach sample of your qvw file?

Andrei