topic Re: Network Day without Saturday in QlikView

Network Day without Saturday

pandiarajan — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Network Day without Saturday

sunny_talwar — Mon, 14 May 2018 11:49:13 GMT

May be see if this helps

Networkdays with saturday

Re: Network Day without Saturday

pandiarajan — Mon, 14 May 2018 12:09:54 GMT

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

sunny_talwar — Mon, 14 May 2018 12:14:45 GMT

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

Re: Networkdays with saturday

Re: Network Day without Saturday

jyothish8807 — Mon, 14 May 2018 12:17:07 GMT

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