https://community.qlik.com/t5/App-Development/aggregate-working-days-formula/m-p/2440520#M97268 <P>Even if features like networkdays() exists I couldn't recommend such approaches because it's much easier to provide these information within a calendar. There each date could be checked per weekday() and mapped against generic and/or fixed holidays to return a 0/1 flag of being a working-day which could be easily summed in the UI.</P> <P>But many more is possible within the calendar by accumulating the flag on weekly/monthly/yearly level and/or aggregating their min/max/avg values and/or relating them to previous/rolling periods in further flags. For nearly all scenarios it should be possible just to pick the wanted values from the calendar instead of calculating such stuff in the UI.&nbsp;</P> Fri, 12 Apr 2024 07:54:29 GMT marcus_sommer 2024-04-12T07:54:29Z https://community.qlik.com/t5/App-Development/aggregate-working-days-formula/m-p/2440404#M97257 <P>Hello,&nbsp;</P> <P>I am trying to get a calculation going using QLIK's networkdays formula, but be able to filter down it's calculation based on a specific month chosen.</P> <P>I currently have a formula looking something like this&nbsp;networkdays(YearStart(Max([%DateLink])), today() ,'01/01/2024','5/27/2024','7/4/2024','9/2/2024','11/28/2024','11/29/2024','12/24/2024','12/25/2024') which is sort of a YTD count of working days.&nbsp;</P> <P>however, I need to get it to where if I have I select previous months this year, it needs to filter down. So if I select MonthYear = Jan, it would only show 22 networkdays.&nbsp;</P> <P>&nbsp;</P> <P>How can I do this?</P> <P>&nbsp;</P> Thu, 11 Apr 2024 20:11:50 GMT https://community.qlik.com/t5/App-Development/aggregate-working-days-formula/m-p/2440404#M97257 jalanhart 2024-04-11T20:11:50Z https://community.qlik.com/t5/App-Development/aggregate-working-days-formula/m-p/2440520#M97268 <P>Even if features like networkdays() exists I couldn't recommend such approaches because it's much easier to provide these information within a calendar. There each date could be checked per weekday() and mapped against generic and/or fixed holidays to return a 0/1 flag of being a working-day which could be easily summed in the UI.</P> <P>But many more is possible within the calendar by accumulating the flag on weekly/monthly/yearly level and/or aggregating their min/max/avg values and/or relating them to previous/rolling periods in further flags. For nearly all scenarios it should be possible just to pick the wanted values from the calendar instead of calculating such stuff in the UI.&nbsp;</P> Fri, 12 Apr 2024 07:54:29 GMT https://community.qlik.com/t5/App-Development/aggregate-working-days-formula/m-p/2440520#M97268 marcus_sommer 2024-04-12T07:54:29Z