Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
BlakeT
Contributor
Contributor

current work day .

I am trying to measure if a report is submitted by a certain work day . I am not sure how to do this .

example:

mydatefield = 2019/04/12. I want to measure if the report was submitted before the 10th work day .

I am able to figure out network days: 23  and day number : 12 . However , what needs to be calculated is the day number in relation to the networkdays ie :  the 12th of April is actually the 10th working day of the month and it is this that I need to calculate.

 

Labels (3)
1 Reply
dilipranjith
Partner
Partner

use networkdays function. e.g. below
NetWorkDays(Date#('2019/04/01','YYYY/MM/DD'),Date#('2019/04/12','YYYY/MM/DD')) returns 10

so maybe in your case
NetWorkDays(MonthStart(YOURDATEFIELD),YOURDATEFIELD)