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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
MigueldelCampo
Contributor III
Contributor III

Best way to calculate, for example, the third business day

Hi! what would be the best way to calculate, for example, the third business day of each month? Using networkdays?  Thanks in advance,

Labels (4)
1 Solution

Accepted Solutions
Or
MVP
MVP

I believe you'd want to use LastWorkDate() for this (or possibly FirstWorkDate(), I always get them mixed up).

View solution in original post

3 Replies
Or
MVP
MVP

I believe you'd want to use LastWorkDate() for this (or possibly FirstWorkDate(), I always get them mixed up).

MigueldelCampo
Contributor III
Contributor III
Author

I understand, but how do I define business days if, for example, Sunday is Christmas? (this year it is like that)

Or
MVP
MVP

You can manually list holidays, the syntax is in documentation so it should be easy to find...