2 Replies Latest reply: May 4, 2018 10:11 AM by Jahanzeb Hashmi RSS

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

    Vinod Chowdary Gadiputi

      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…?