How to select days from today to year end with set?
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?
Re: How to select days from today to year end with set?
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.