Excluding holidays in calculation.....( Qlik Sense)
I need to calculate no of days taken to unload truck from the date it has arrived inside the factory.
The process of documentation involves following steps,
Step1: Gate Entry:- When truck enters inside the gate, gate keeper will create a GateEntryID and records the date.
Step2: Documentation:- When Truck unloading is done, Respective person will create Document Number and records date as well (they will refer GateEntryID which has been created against this respective truck).
Here, I need to calculate no of days between Gate Entry Date and Document Date, and I need exclude their holidays (they have specific public holidays, all Sundays and 2nd & 3rd Saturdays of every month.)
They have calendar but there it is not having relation with any other data table.