topic Re: Calculate duration (creationdate - closuredate) in QlikView

Calculate duration (creationdate - closuredate)

Wed, 25 Jul 2012 13:53:30 GMT

Hello,

I'm trying to calculate the duration of creation and closure date.

Tried the following:

SQL SELECT

datumaangemeld AS IN_DATE_creation_date

datumafgemeld AS IN_DATE_closure_date,

datumafgemeld - datumaangemeld AS IN_DATE_duration,

FROM db;

Above code is not working, any suggustions?

I would like to have the data stored as hours:mins:seconds

Thanks!

Screenshot seems not to be working so here table information:

IN_DATE_creation_date	IN_DATE_closure_date
10/29/2004 9:54:00 PM	10/29/2004 9:59:01 PM
10/30/2004 10:00:00 PM	10/30/2004 10:11:01 PM

nagaiank — Wed, 25 Jul 2012 14:12:05 GMT

Try the following:

LOAD datumaangemeld AS IN_DATE_creation_date

datumafgemeld AS IN_DATE_closure_date,

datumafgemeld - datumaangemeld AS IN_DATE_duration;

SQL SELECT

datumaangemeld

datumafgemeld

FROM db;

Displaying the duration in hh:mm:ss can be achieved by specifying the format in the 'Number' tab of chart properties.

Wed, 25 Jul 2012 14:24:54 GMT

Screenshot was not working here table information:

IN_DATE_creation_date	IN_DATE_closure_date
10/29/2004 9:54:00 PM	10/29/2004 9:59:01 PM
10/30/2004 10:00:00 PM	10/30/2004 10:11:01 PM

Wed, 25 Jul 2012 14:28:29 GMT

Just tried it, looks working; Altough when a duration longer then 24 hours its not working correlty anymore.

nagaiank — Wed, 25 Jul 2012 14:31:55 GMT

For the duration field, in the Number tab, chose interval format 'dd hh:mm:ss'

Wed, 25 Jul 2012 14:43:09 GMT

Thank you, works! also my old code works with just the field adjustments.