https://community.qlik.com/t5/App-Development/of-Selling-Days/m-p/2447210#M97732 <P>Hi,&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/297530">@lneff</a>&nbsp;<BR /><BR />I would work this into the script by bringing in these holidays with a mapping, using either an inline or a table for holidays. <BR />Then you could create a flag and later use it in your application.<BR /><BR />See the example below; this is just an example and you can adapt it to your data if you find it useful.<BR /><BR /></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MatheusC_3-1714505535991.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/165174i737AA7E6055C991B/image-size/medium?v=v2&amp;px=400" role="button" title="MatheusC_3-1714505535991.png" alt="MatheusC_3-1714505535991.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> <P><BR />Regarts, Matheus</P> Tue, 30 Apr 2024 19:32:29 GMT MatheusC 2024-04-30T19:32:29Z https://community.qlik.com/t5/App-Development/of-Selling-Days/m-p/2447186#M97730 <P>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.&nbsp;</P> <P>This is my expression for the quarter:</P> <P>NetWorkDays(Date(today(),'5/27/2024'),QuarterEnd(Date(today(),'5/27/2024')))</P> <P>And the year:&nbsp;</P> <P>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')))</P> <P>&nbsp;</P> Tue, 30 Apr 2024 18:09:21 GMT https://community.qlik.com/t5/App-Development/of-Selling-Days/m-p/2447186#M97730 lneff 2024-04-30T18:09:21Z https://community.qlik.com/t5/App-Development/of-Selling-Days/m-p/2447210#M97732 <P>Hi,&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/297530">@lneff</a>&nbsp;<BR /><BR />I would work this into the script by bringing in these holidays with a mapping, using either an inline or a table for holidays. <BR />Then you could create a flag and later use it in your application.<BR /><BR />See the example below; this is just an example and you can adapt it to your data if you find it useful.<BR /><BR /></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MatheusC_3-1714505535991.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/165174i737AA7E6055C991B/image-size/medium?v=v2&amp;px=400" role="button" title="MatheusC_3-1714505535991.png" alt="MatheusC_3-1714505535991.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> <P><BR />Regarts, Matheus</P> Tue, 30 Apr 2024 19:32:29 GMT https://community.qlik.com/t5/App-Development/of-Selling-Days/m-p/2447210#M97732 MatheusC 2024-04-30T19:32:29Z