Qlikview calculating two dates TAT only excluding the holidays

[EQ]

Hi QV experts,

I know QlikView has a function NetWorkDays() to calculate two dates, but it will exclude the Sat and Sun. 

What I want to calculate the TAT of two dates only excludes the holidays which loaded from an excel.

Like we have two dates 2018-12-27 and 2019-01-03, meanwhile, 2019-12-31 and 2019-01-01 are holidays, to calculate the TAT, it should return 5 as below.  Would a kind and enlightened please advise on my error, many thanks in advance.

DateAct	DateSent	TAT
2018/12/27	2019/1/3	5

[VishalWaghole]

Create your holiday mapping with you calendar and assign flag against holiday date.

In set analysis use flag only for working days which will give you saturday and sunday but not holidays.

Thanks,
Vishal Waghole

[EQ]

Hi Vishal,

Thanks for your response, but I have to calculate the TAT in backend load scripts, could you please let me know if you have any ideas?

Thanks,

Eric