Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pandiarajan
Creator
Creator

Network Day without Saturday

Dear All,

As my current client requirement, I want to calculate monthly project of the sales. They are given a specific list of Public holiday list based on I need to calculate how many working days between the particular time period.

As I used Network day function I could be able to exclude Saturday, Sunday and my public holiday. But my client requirement we need only exclude Sunday and list of a public holiday.

Kindly someone suggests me the good solution ]

Thanks & Regards,

Pandiarajan.R

4 Replies
sunny_talwar

May be see if this helps

Networkdays with saturday

pandiarajan
Creator
Creator
Author

Hi Sunny ,

     Thank You for Your Solution!

I wanted to Exclude list of the Public holiday as well as . one more thing Is there any other alternate solution to solve this issue because of My solution architect not accepting Macro code

Thanks & Regards,

Pandiarajan.R

sunny_talwar

Did you see rbecher‌'s response to do this in the script

Re: Networkdays with saturday

jyothish8807
Master II
Master II

Go through the same blog, there is one more solution mentioned in the bottom without macros.

Best Regards,
KC