Counting working days this week / month

[bwisealiahmad]

So in an excel sheet there is a column called "Days this week" which counts:

Monday as 1,

Tuesday as 2,

Wednesday as 3

(only Mon-Fri)

++

And another column called Days This Month that also works as a counter of working days from the first day of the month as 1, second as 2 etc. and want this to automatically be done for each month.

I want to create these fields based on a budget date.

I've heard about "Network" days, but not sure how to get to this.

Any tips anyone?

[bwisealiahmad]

I tried this just to test and it says the flag doesn't exist? Weird. I tried to move the calendar gen forward in the script also. Does sub routines get generated any later because it is a subroutine?

[sunny_talwar]

I have not used SubRoutines before so I would not know about this. but are you saying that although the Flag was already created  it threw an error at you? Can you share the subroutine script?

[bwisealiahmad]

Correct!

That is weird. First time I have noticed this. The Flag is available in front end, but not in back end. Maybe that is how it is when it is generated based on a field? The subroutine is an edited version of the master calendar from the qlik deployment framework. It's quite large. Let me try some things and I'll check back in later.

Thanks for all the help again.

[sunny_talwar]

No problem.... one thing to check is that SubRoutines take parameters and you might have to add Flag is another parameter so that you can use it. I am not sure how exactly it will work... but may be you can look into it at your end