Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Interval - Convert seconds into days of 8 hours.

Hi All,

I retrieve data where I have seconds on every line. I'm totalling the rows and using Interval to convert seconds into 'd hh:mm:ss' which is working fine, however the days are taken as 24 hour days where I would like to specify the no of hours per day.

My current interval line is as follows :-

Interval(Interval#(ActualWorkTime,'ss'),'d hh:mm:ss') as ActualTimeH,

which is returning the table below. What do I need to do to the above line to set an 8 hour day?

Thanks

Steve

1 Solution

Accepted Solutions
Not applicable

can't you multiply by 3?

View solution in original post

3 Replies
Not applicable

can't you multiply by 3?

View solution in original post

=Dual(Div(ActualWorkTime,28800)&' '&Interval(fmod(ActualWorkTime,28800)/86400, 'hh:mm:ss'), ActualWorkTime)

QlikCommunity_Thread_145508_Pic1.JPG

Hi,

can you post an example app?

thanks

regards

Marco