topic Re: Time subtract between two time stamps in QlikView

Time subtract between two time stamps

Qlik__Vinodh — Wed, 03 Sep 2014 09:24:21 GMT

Dear All,

How to subtract this Timestamp( Start_Time - End_Time).

if any one knows this help me.

PFA for example file.

PrashantSangle — Wed, 03 Sep 2014 09:27:02 GMT

Hi,

Use Interval().

For details see in help menu.

Regards

tresB — Wed, 03 Sep 2014 09:29:40 GMT

Try like:

Load

Interval(Time#(End_Time, 'hh:mm:ss TT')-Time#(Start_Time, 'hh:mm:ss TT'), 'hh:mm:ss') as TimeDiff

Update: 'TT' not 'tt'

senarath — Wed, 03 Sep 2014 09:29:44 GMT

Hi,

Function is Interval.

=Interval(time02 - Time01,'hh:mm')

thanx

jagan — Wed, 03 Sep 2014 09:39:08 GMT

Hi,

Try like this

=Interval(Timestamp#('3:19:21 AM', 'h:m:ss TT')

- Timestamp#('3:15:00 AM', 'h:m:ss TT'), 'h:m:ss TT')

LOAD

Interval(Timestamp#(EndTime, 'h:m:ss TT')

- Timestamp#(StartTime, 'h:m:ss TT'), 'h:m:ss TT') AS TimeDifference

From DataSource;

Regards,

Jagan.

aveeeeeee7en — Wed, 03 Sep 2014 09:46:17 GMT

Create a field in your backend Script:

Interval(END_TIME - START_TIME,'hh:mm:ss') AS Time_Subtract

It will give you desired Result.

Also, see the Attachment.

Regards

Aviral Nag

MK_QSL — Wed, 03 Sep 2014 09:47:03 GMT

Add one more line in your script...

Interval(Time#(END_TIME,'h:mm:ss TT')-Time#(START_TIME,'h:mm:ss TT'),'h:m:ss') as TimeDifference