Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

pandiarajan
Contributor

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

Re: Network Day without Saturday

May be see if this helps

Networkdays with saturday

pandiarajan
Contributor

Re: Network Day without Saturday

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

Re: Network Day without Saturday

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

Re: Networkdays with saturday

jyothish8807
Honored Contributor II

Re: Network Day without Saturday

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

Best Regards,
KC