6 Replies Latest reply: Apr 19, 2012 8:28 PM by Michael Solomovich RSS

    Calculate working days between to dates during load

      Hi,

      I'm a newbie in qlikview and i've this scenario:

       

      I' ve a table with to dates: enddate and startdate; I need to calculate the number of working days between the two during load and add a new field with it, how can I do it?

      I need to check each date between startdate and enddate to see if it is a working day or a holiday. I tried to use a routine, but I can´t get i to work inside load statement. The holidays are in another table.

      Tks,

      Luis