Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

danm84306
New 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
Employee
Employee

Re: Turn timestamp into interval

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

3 Replies
Employee
Employee

Re: Turn timestamp into interval

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
New Contributor III

Re: Turn timestamp into interval

Hello,

     THis worked perfectly, Thank you!

MVP
MVP

Re: Turn timestamp into interval

see attachment

no script, only expression for second column

1.png

Community Browser