topic Re: How to find TAT in QlikView

How to find TAT

shrusrkt — Wed, 25 Nov 2020 16:16:04 GMT

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 — Sat, 20 Jan 2018 08:44:36 GMT

Three condition or single condition?

shrusrkt — Sat, 20 Jan 2018 09:24:46 GMT

3 conditions

Anil_Babu_Samineni — Sat, 20 Jan 2018 09:59:15 GMT

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

swuehl — Sat, 20 Jan 2018 10:06:15 GMT

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