7 Replies Latest reply: Sep 8, 2016 12:21 PM by Stefan Wühl RSS

    Change Weekend in NetWorkDays Function

    Feras Alsuhaibani

      Hello everyone!

       

      Is it possible to change the weekend of the function Networkdays by passing a parameter or something like that? Our weekend is Friday and Saturday, and the default of Qlik Sense is Saturday and Sunday. I tried changing FirstWeekDay to the following:

       

      SET FirstWeekDay=6;

      Also changed the Daynames but with no luck, Sunday gets excluded from the calculation.

       

      I found a few solutions such as NetworkingDays(DateA+1, DateB+1) but it gives incorrect numbers.

       

      Your help is appreciated!