topic Difference Between Consecutive Time ???? in QlikView

Difference Between Consecutive Time ????

Tue, 07 May 2013 07:21:47 GMT

Hi all,

I need to have difference between two consecutive dates of the same column.

I am trying the expression as (login time)-above (login time), still getting no success.

Any sort of help in same is appreciated.

Sample excel file has been attached for reference.

Thanks

Mayank

Re: Difference Between Consecutive Time ????

kumarnatarajan — Tue, 07 May 2013 07:33:02 GMT

Hi,

Please find the attached file.

Script:

Temp:

LOAD * INLINE [
    Login Time
    5/2/2013 8:18:05 AM
    5/2/2013 8:18:31 AM
    5/2/2013 10:18:06 AM
    5/2/2013 10:18:09 AM
    5/2/2013 10:24:28 AM
    5/2/2013 11:11:10 AM
    5/2/2013 11:11:13 AM
    5/2/2013 11:15:24 AM
    5/2/2013 4:45:35 PM
    5/2/2013 4:45:38 PM

];

NoConcatenate LOAD [Login Time],Interval([Login Time]-Previous([Login Time])) as Difference Resident Temp;
DROP Table Temp;

Re: Difference Between Consecutive Time ????

fdelacal — Tue, 07 May 2013 07:38:14 GMT

PLEASE SEE QVW ATACH

HOPE THAT HELPS YOU REGARDS.

THE FIELD DIFERENCA IS I CREATE WITH THE DIFERENCES