Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
lneff
Contributor
Contributor

# of Selling Days

I'm trying to show how many days left in the quarter and year using NetWorkDays. Its not recognizing the holidays I'm entering. I should show 43 days left in the quarter and its showing 44. 

This is my expression for the quarter:

NetWorkDays(Date(today(),'5/27/2024'),QuarterEnd(Date(today(),'5/27/2024')))

And the year: 

NetWorkDays(Date(today(),'1/01/2024''5/27/2024''7/04/2024''9/02/2024''11/21/2024''11/22/2024''12/25/2024'),YearEnd(Date(today(),'1/01/2024''5/27/2024''7/04/2024''9/02/2024''11/21/2024''11/22/2024''12/25/2024')))

 

Labels (1)
1 Reply
MatheusC
Specialist
Specialist

Hi, @lneff 

I would work this into the script by bringing in these holidays with a mapping, using either an inline or a table for holidays.
Then you could create a flag and later use it in your application.

See the example below; this is just an example and you can adapt it to your data if you find it useful.

MatheusC_3-1714505535991.png

 

 


Regarts, Matheus

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!