FirstWorkDate() Help

[joshrussin]

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"

[sunny_talwar]

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

[sunny_talwar]

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)

[joshrussin]

Yes, 30 is correct! Thanks.

[joshrussin]

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

[sunny_talwar]

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

[sunny_talwar · Accepted solution]

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';

[joshrussin]

Thanks so much! Got it!