1 Reply Latest reply: Mar 27, 2017 7:15 AM by Sunny Talwar RSS

    Counting of task due date in Qlik Sense

    Michael Ang

      Hi,

       

      Need help. I have an issue with counting the due date of a task, if the start date of the task falls on weekend. The due date for a task is 5 working days from the start date.

       

      For example.

      If the start date is 18/03/2017, with 5 working days, the task should be due on 27/03/2017.

      If the start date is 19/03/2017, the task is also due on 27/03/2017.

       

      I tried using Lastworkdate but can't make it work for both Saturdays and Sundays.

       

      Any suggestions?