Qliksense Time Calculation

[krmvacar]

Hi All,

Example:

Name       Workstart                       Workend                   Time Work(Minutes)
John         01.12.2021 08:26     01.12.2021 09:58      92 minutes
                    01.12.2021 08:45     01.12.2021 10:06        8 minutes

As you can see in the example above, since the second start time is within the first end time, I need to accept the first end time as the start and calculate the difference with the second end time.

How can I do this with calculation method in expression ?

Your help is requested.

[vinieme12]

Try below

Dimension = Name

Measure=Interval(min(Workstart) - max(WorkEnd),'mm' )

[krmvacar]

Hi , @vinieme12  ,

ı try but its not working.

ıts must be total 519 mınutes.

I want to show  example.JPG  show.

Thanks

[PrashantSangle · Accepted solution]

Hi, 

Used below expression 

if(Interval(Workend - Timestamp(RangeMax(Above(total Workend,0,3))))<0,0,
Interval(Workend - if(Workstart<Above(Total Workend),Above(Total Workend),Workstart),'mm'))

Regards,

Prashant Sangle

[PrashantSangle]

if you want the total also then use below expression

Num(Num#(if(Interval(Workend - Timestamp(RangeMax(Above(total Workend,0,3))))<0,0,
Interval(Workend - if(Workstart<Above(Total Workend),Above(Total Workend),Workstart),'mm')),'###0'))

and formating tab > select sum

Regards,

Prashant Sangle

[krmvacar]

Thank you so much