Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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 (2)
1 Reply
dplr-rn
Partner - Master III
Partner - Master III

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)