Solved: Re: Time between two time stamps - Qlik Community

vishsaggi · ‎2015-05-05

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

like

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

Regards,
V.

Gysbert_Wassenaar · ‎2015-05-05

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.

talk is cheap, supply exceeds demand

View solution in original post

Gysbert_Wassenaar · ‎2015-05-05

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.

talk is cheap, supply exceeds demand

nagarjuna_kotha · ‎2015-05-05

Hi,

Can u share sample file ?

Regards,
Nagarjuna