topic Re: Time between two time stamps in QlikView

Time between two time stamps

vishsaggi — Tue, 05 May 2015 09:21:56 GMT

Hello ,

I am looking for a set analysis statement to check a timestamp field between two time intervals.

I have timestamp field with time I want to check this field between two times

Timestamp between Time1= 9:00:00 Am and Time2 = 11:00:00

Regards,
V.

Re: Time between two time stamps

Gysbert_Wassenaar — Tue, 05 May 2015 09:36:13 GMT

Subtract the two times from each other: Time2 - Time1. You can use the interval function to format the result: interval(Time2-Time1, 'h:mm:ss').

If the time values are strings and not numbers then first convert them to numbers with the time# function. time#(Time1, 'h:mm:ss') as Time1. If they are timestamp strings then use the timestamp# function: timestamp#(MyTimeStamp, 'YYYY-MM-DD hh:mm:ss') as MyTimeStamp.

Re: Time between two time stamps

nagarjuna_kotha — Tue, 05 May 2015 09:52:19 GMT

Hi,

Can u share sample file ?

Regards,
Nagarjuna