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: 
gp_123
Contributor III
Contributor III

To include Saturday count in Networkdays

Hello Everyone,
I am working on the one of the project. I am calculating Pending for Field and for that I write this Expression.
IF(Area='Capgemini', NetWorkDays(TsOpeningDate,Today(),$(vCampgemini))-1,
NetWorkDays(TsOpeningDate,Today(),$(vOtherHolidays))-1) as Pending_for

Now i want to add Sat count into the same logic as networkdays function automatically excludes Sat Sun.
To add sat Count I performed this logic   -    Div(WEEKDAY(Min(TsOpeningDate)-6,0)+1-Min(TsOpeningDate)+Max(TsOpeningDate),7)           using this logic I am getting number of sat between two dates but I am not getting how to combine this with the above logic.

How I can achieve this? If anyone have any idea please let me know.

Regards,

Ganesh

Labels (1)
0 Replies