Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
danm84306
Contributor III
Contributor III

Turn timestamp into interval

Hello,

     I am looking to return the interval a time stamp occured in. for example, 00:01:43 08/02/2014 would return as 00:00:00 to 00:30:00 interval.

1 Solution

Accepted Solutions
Agis-Kalogiannis
Employee
Employee

Hi Dan

I have prepared an application for you, where it creates some timestamps, from these timestamps it isolates the frac (decimal places which show the time), and maps them into time periods...

I hope this helps

Agis

View solution in original post

3 Replies
Agis-Kalogiannis
Employee
Employee

Hi Dan

I have prepared an application for you, where it creates some timestamps, from these timestamps it isolates the frac (decimal places which show the time), and maps them into time periods...

I hope this helps

Agis

danm84306
Contributor III
Contributor III
Author

Hello,

     THis worked perfectly, Thank you!

maxgro
MVP
MVP

see attachment

no script, only expression for second column

1.png