topic Re: Time Interval in QlikView

Time Interval

Tue, 30 Jun 2015 11:47:05 GMT

I Have 2 Tables

Received:

Released:

How can i find the difference between Released_DateTime and Received_DateTime

Thanks

buzzy996 — Tue, 30 Jun 2015 11:49:27 GMT

try tis way,

=Interval(Interval(Sum(ProProductiveTime),'hh:mm:ss') -Interval(Sum(ProNonProductiveTime),'hh:mm:ss'),'hh:mm:ss')

use ur fields on the above expression

sunny_talwar — Tue, 30 Jun 2015 12:02:15 GMT

There are multiple TRN_Released in both the tables. Which ones do you need to calculate the difference?

avinashelite — Tue, 30 Jun 2015 12:08:26 GMT

Hi Senthil,

In order to find the interval , the compare based on the unique key other wise this yield in wrong result

Tue, 30 Jun 2015 12:11:49 GMT

In the above table , Received_DateTime is from table1 and the other from table2

Key is the Concatenated Column .

sunny_talwar — Tue, 30 Jun 2015 12:16:46 GMT

Is this the output you are expecting?

If yes then you can use the following script:

Table1:

LOAD *,

Interval(Released_DateTime - Received_DateTime, 'D hh:mm:ss') as Difference;

LOAD Key,

Timestamp#(Received_DateTime, 'DD/MM/YYYY hh:mm:ss') as Received_DateTime,

Timestamp#(Released_DateTime, 'DD/MM/YYYY hh:mm:ss') as Released_DateTime;

LOAD * Inline [

Key, Received_DateTime, Released_DateTime

20150309-00029814_1, 10/03/2015 02:28:16, 01/04/2015 15:07:25

20150309-00029814_2, 01/04/2015 16:19:02, 01/04/2015 17:28:30

20150312-00004425_1, 12/03/2015 03:47:29, 01/04/2015 10:52:52

20150312-00004425_2, 01/04/2015 14:20:03, 01/04/2015 14:50:40

20150316-00001394_1, 17/03/2015 02:21:09, 07/04/2015 16:33:07

20150316-00001394_2, 08/04/2015 02:51:44, 08/04/2015 7:21:39

];

HTH

Best,

Sunny