Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
With a set I´d like to select the remaning workdays from today to end of the year to get the number of days left and the use that expression to divide on another expression.. The purpuse is to show how many new customers per day it takes to fullfill the goal (of 250 per year). The 2nd expression gives how many new customers they have signed up to current date.
I have a master calendar with day names of the week so I was thinking that maybe start with selecting monday-friday and then from the date-calendar remove certain fixed dates (holidays). How can that be done?
=networkdays(today(),yearend(today()) will return the number of workdays from today until the end of this year
=networkdays(today(),yearend(today()) will return the number of workdays from today until the end of this year
Hello,
By using Interval you can find the number of days left in this year.
=Interval(YearEnd(Today())-Today(),'D')
So that gives me mon-fri with no holidays? And then I manually load a inline variable with holidays that fals on mon-fri?
Thanks
If you know the holidays you can add them to the networkdays function as 3rd, 4th,... n-th parameter. As holidays are usually country (or region or even business) specific Qlikview can't know what the holidays are. So networkdays has the option to add the holiday dates as parameters to the function. See the help file for details.