How to find TAT - Qlik Community

shrusrkt · ‎2018-01-20

Hi all,

1) I want to find TAT excluding Saturdays and Sundays and public holidays.

2) I want to find TAT for. (difference between Last_resolved_Date-Created_Date). My field is in timestamp foemat.

3) Next is I want to find TAT, If Time is before 9:30 AM it should display 9:30 AM & if time is after 6:30 it should display today()+1.

I used nested if condition for this but I was unable to resolve my problem.

Please help.

Anil_Babu_Samineni · ‎2018-01-20

Three condition or single condition?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

shrusrkt · ‎2018-01-20

3 conditions

Anil_Babu_Samineni · ‎2018-01-20

Please read this https://community.qlik.com/docs/DOC-16489 you will get conclude with this link.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

swuehl · ‎2018-01-20

1) You can have a look at the NetWorkDays() function to get the working days in a time span excluding saturdays, sundays and holidays.

2) Difference between two timestamps can just be calculated like that, and formatted using Interval()

=Interval(Timestamp2 -Timestamp1)

3) If you need more complex calculations, considering working hours and holidays / weekends, have a look at

Calculate hours between two Date/Time strings