Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
MigueldelCampo
Contributor II
Contributor II

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 II
Contributor II
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...