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!