Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to select days from today to year end with set?

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? 

1 Solution

Accepted Solutions
Gysbert_Wassenaar

=networkdays(today(),yearend(today())  will return the number of workdays from today until the end of this year


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
Gysbert_Wassenaar

=networkdays(today(),yearend(today())  will return the number of workdays from today until the end of this year


talk is cheap, supply exceeds demand
jagannalla
Partner - Specialist III
Partner - Specialist III

Hello,

By using Interval you can find the number of days left in this year.

=Interval(YearEnd(Today())-Today(),'D')

Not applicable
Author

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

Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand