Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
ahmada
Contributor II
Contributor II

Dynamic Network Days expression

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.NetworkDate.PNG

1 Solution

Accepted Solutions
2 Replies
tresesco
MVP
MVP

Check here : your another post 

Brett_Bleess
Former Employee
Former Employee

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

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.