topic Re: TAT calculation in QlikView

TAT calculation

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

hi all,

I got a requirement to calculate TAT

I got process,sub-process,start time end time received time

I need to calculate TAT every 2nd working day of the Month ,excluding weekends and holidays

how can I create a flag 2nd working day of month in the script

please help me

Re: TAT calculation

tresB — Tue, 22 Nov 2016 07:21:35 GMT

May be like:

Load

If (YourDateField=lastWorkDate(MonthStart(YourDateField),2), 1,0) as SecondWdayFlag

Re: TAT calculation

nareshthavidishetty — Tue, 22 Nov 2016 07:48:33 GMT

not working

Re: TAT calculation

tresB — Tue, 22 Nov 2016 07:56:55 GMT

Could you post a qvw with sample data?

Re: TAT calculation

nareshthavidishetty — Tue, 22 Nov 2016 08:07:19 GMT

sorry flag is working now and I want to calculate the TAT based on this so how to handle this things

logic is end date time-received date time for tat calculation so please tell me I need to consider excluding weekends and holidays while calculating TAT

Re: TAT calculation

tresB — Tue, 22 Nov 2016 09:00:56 GMT

Sorry, I could really not understand your requirement.

Re: TAT calculation

veeranj — Tue, 22 Nov 2016 09:15:05 GMT

Hi ,

Try filtering weekends from your mastercalendar with below script

load * resident mastercalendar where not match(weekDay,'Sat','Sun') ;

and use below script

load Month,FirstSortedValue([Facts_Dates],[Facts_Dates],2) as sec,'Y' as flag Resident MasterCalendar group by Month;

which will give 2nd working date in each month .

Thanks,

Anjee

Re: TAT calculation

nareshthavidishetty — Tue, 22 Nov 2016 12:11:02 GMT

I'm calculating TAT , I don't know how to calculate TAT

end date time-received date time gives TAT time excluding sat, Sunday holidays

so I need to build which processes TAT met and not met

the reason y I asked 2nd working day of every month is if the process received date is on 3rd it is missed TAT so I need to build in the script whether that process received on that day or later

is it clear or do I need to specify more in details please ask me I'm in need of help as I don't no how to handle this things

process,start date time ,end date time, received date time fields I'm using this fields

I build calender excluding sat,sun

Re: TAT calculation

nareshthavidishetty — Tue, 22 Nov 2016 12:52:21 GMT

I'm calculating TAT , I don't know how to calculate TAT

end date time-received date time gives TAT time excluding sat, Sunday holidays

so I need to build which processes TAT met and not met

the reason y I asked 2nd working day of every month is if the process received date is on 3rd it is missed TAT so I need to build in the script whether that process received on that day or later

is it clear or do I need to specify more in details please ask me I'm in need of help as I don't no how to handle this things

process,start date time ,end date time, received date time fields I'm using this fields

I build calender excluding sat,sun