topic Re: Getting info from latest business day in QlikView

Getting info from latest business day

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)

Re: Getting info from latest business day

antoniotiman — Mon, 03 Jul 2017 15:45:53 GMT

Hi,

maybe

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

Regards,

Antonio

Re: Getting info from latest business day

joshrussin — Mon, 03 Jul 2017 16:14:26 GMT

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!

Re: Getting info from latest business day

joshrussin — Mon, 03 Jul 2017 16:24:03 GMT

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.

Re: Getting info from latest business day

antoniotiman — Mon, 03 Jul 2017 16:32:27 GMT

Sintax seems correct.

Can You provide Your app ?

Re: Getting info from latest business day

joshrussin — Mon, 03 Jul 2017 16:38:10 GMT

Daily Summary sheet.

Text box that says "Help here"

Re: Getting info from latest business day

joshrussin — Mon, 03 Jul 2017 20:08:25 GMT

That help?