Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
MVP & Luminary
MVP & Luminary

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

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


talk is cheap, supply exceeds demand
4 Replies
MVP & Luminary
MVP & Luminary

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

=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
Valued Contributor III

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

Hello,

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

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

Not applicable

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

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

MVP & Luminary
MVP & Luminary

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.


talk is cheap, supply exceeds demand
Community Browser