topic Re: FirstWorkDate() Help in QlikView

FirstWorkDate() Help

joshrussin — Wed, 25 Nov 2020 16:16:04 GMT

I am trying to figure out how to get "Processed_Dash" from my table based on latest business day. I want to account for holidays as well. I am trying to put this into an equation and it returns nothing. Maybe syntax, still new to qlik. I am putting this information into a textbox equation.

holidays = '1/2/2017', '5/29/2017', '7/4/2017', '11/23/2017', '11/24/2017', '12/25/2017', '12/26/2017';

=Sum({$<Date_Dash={"$(FirstWorkDate(Today()-1,1,$(holidays)))"},Program_Dash={'Mechanical Inspection'}, Status_Dash={'Completed'}>} Processed_Dash)

App attached, "Daily Summary" sheet, text box that says "help here"

Re: FirstWorkDate() Help

sunny_talwar — Wed, 05 Jul 2017 14:16:59 GMT

I don't see holidays variable in your app...Did you attach the correct app?

Re: FirstWorkDate() Help

sunny_talwar — Wed, 05 Jul 2017 14:18:09 GMT

After creating the variable, this is giving me 30... is this right?

=Sum({$<Date_Dash={"$(=FirstWorkDate(Today()-1,1,$(holidays)))"},Program_Dash={'Mechanical Inspection'}, Status_Dash={'Completed'}>} Processed_Dash)

Re: FirstWorkDate() Help

joshrussin — Wed, 05 Jul 2017 14:28:57 GMT

Yes, 30 is correct! Thanks.

Re: FirstWorkDate() Help

joshrussin — Wed, 05 Jul 2017 14:32:27 GMT

How did you enter it as a variable? It keeps showing an error after ","

Re: FirstWorkDate() Help

sunny_talwar — Wed, 05 Jul 2017 14:33:08 GMT

I added it on the front end of the app.... are you doing this in the script?

Re: FirstWorkDate() Help

sunny_talwar — Wed, 05 Jul 2017 14:33:39 GMT

May be try this

SET holidays = '1/2/2017', '5/29/2017', '7/4/2017', '11/23/2017', '11/24/2017', '12/25/2017', '12/26/2017';

Re: FirstWorkDate() Help

joshrussin — Wed, 05 Jul 2017 14:37:42 GMT

Thanks so much! Got it!