Getting info from latest business day

[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)

[antoniotiman]

Hi,

maybe

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

Regards,

Antonio

[joshrussin]

That didn't seem to work either. Unless you have a different way of getting the Processed_Dash of the last business day, including holidays. Thank you!

[joshrussin]

FirstWorkDate(Date(Max(Date_Dash)-1),1)

If I just put that into a text box, it will show the previous business day. I just cannot figure out the syntax for putting it in a search query.

[antoniotiman]

Sintax seems correct.

Can You provide Your app ?

[joshrussin]

Daily Summary sheet.

Text box that says "Help here"

[joshrussin]

That help?