topic TAT Calculation with Excluding saturday,sunday and Holidays! in QlikView https://community.qlik.com/t5/QlikView/TAT-Calculation-with-Excluding-saturday-sunday-and-Holidays/m-p/1122955#M904189 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>I wants to calculate TAT in between days like Assigned Date and Completed Date but by excluding holidays and weekend(Sat ,Sun). And also there is one condition if that request is within tat then TAT remarks is Within TAT else Exceeds TAT.</P><P></P><TABLE><TBODY><TR><TD>Type Request</TD><TD>Benchmark TAT</TD></TR><TR><TD>Simple</TD><TD>T+3</TD></TR><TR><TD>Medium</TD><TD>T+7</TD></TR><TR><TD>Complex</TD><TD>T+15</TD></TR></TBODY></TABLE><P></P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 12pt; font-family: Calibri; color: black;">Thank you in advance,</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 12pt; font-family: Calibri; color: black;"><BR /></SPAN></P><P><SPAN style="color: #000000; font-size: 16px; font-family: Calibri;">Rupali</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT rupaliqlik 2020-11-25T16:16:04Z TAT Calculation with Excluding saturday,sunday and Holidays! https://community.qlik.com/t5/QlikView/TAT-Calculation-with-Excluding-saturday-sunday-and-Holidays/m-p/1122955#M904189 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>I wants to calculate TAT in between days like Assigned Date and Completed Date but by excluding holidays and weekend(Sat ,Sun). And also there is one condition if that request is within tat then TAT remarks is Within TAT else Exceeds TAT.</P><P></P><TABLE><TBODY><TR><TD>Type Request</TD><TD>Benchmark TAT</TD></TR><TR><TD>Simple</TD><TD>T+3</TD></TR><TR><TD>Medium</TD><TD>T+7</TD></TR><TR><TD>Complex</TD><TD>T+15</TD></TR></TBODY></TABLE><P></P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 12pt; font-family: Calibri; color: black;">Thank you in advance,</SPAN></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 12pt; font-family: Calibri; color: black;"><BR /></SPAN></P><P><SPAN style="color: #000000; font-size: 16px; font-family: Calibri;">Rupali</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/TAT-Calculation-with-Excluding-saturday-sunday-and-Holidays/m-p/1122955#M904189 rupaliqlik 2020-11-25T16:16:04Z