topic Re: Dynamic Network Days expression in QlikView

Dynamic Network Days expression

ahmada — Thu, 28 Nov 2019 13:35:31 GMT

Hello,
I have a question about the formula "networkdays()".
I have a calendar with %Date and Year and in the script the holidays defined as variable.

I would like to select a year and have the days calculated from the beginning of the selected year.

I tried this formula: networkdays(YearStart(%Datum), today() ,vHolidays). Unfortunately the (YearStart(%Datum) does not work in the function.

But the formula = networkdays(YearStart(today()), today() ,vHolidays) works. But I want to filter with the year.

I hope you can help me. Kind regards Ahmad.

tresB — Thu, 28 Nov 2019 13:46:08 GMT

Brett_Bleess — Tue, 10 Dec 2019 19:40:46 GMT

The 'your another post' link provided above is to a duplicate post where the answer lies, just wanted to clarify things.

Regards,
Brett