Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vinod_gadiputi
New Contributor III

Excluding holidays in calculation.....( Qlik Sense)

Hi,

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.

Can anyone help me out in this…?  

2 Replies
YoussefBelloum
Esteemed Contributor

Re: Excluding holidays in calculation.....( Qlik Sense)

zebhashmi
Valued Contributor

Re: Excluding holidays in calculation.....( Qlik Sense)

Yap, I second Networkdays()

Community Browser