Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
villegasi03
Creator
Creator

Adding a Flag to Holidays

QV Community,

I have a list of company holidays that I would like to join to a table containing daily sales statistics. I am planning to perform an analysis on our sales performance on days that fall on those holidays, the day before the holiday and the day after a holiday. I am familiar with the firstworkday and lastworkday functions so I am able to calculate those dates. What would be the best way to flag these dates?

I was hoping that someone could provide some advice on how to do this.

Thank you

1 Solution

Accepted Solutions
Not applicable

Hi,

I did that once using the function networkdays:

Load

A,

B,

Date,

if(networkdays(Date,Date,[list of holydays])=1,'Working day', 'Holyday') as HolydayFlag

from ...

Hope this helps

Regards!

View solution in original post

2 Replies
Not applicable

Hi,

I did that once using the function networkdays:

Load

A,

B,

Date,

if(networkdays(Date,Date,[list of holydays])=1,'Working day', 'Holyday') as HolydayFlag

from ...

Hope this helps

Regards!

villegasi03
Creator
Creator
Author

Worked like a charm! Thank you.