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

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

    vinod gadiputi



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