https://community.qlik.com/t5/App-Development/How-to-get-previous-working-day/m-p/1708482#M54356 <P><BR />Hi everybody,</P><P>I have a calendar table with a flag that indicates working days.</P><P><BR />So in my formule I need to get previous working date (from my calendar if possible), and in another previous previous working day.<BR />Here I do it for previous day (-1) (the vMaxDate is the min between selected date and my max Qvd date) :<BR />sum({1&lt;[Statut]={'LOG'}, Date={$(=$(vMaxDate)-1)}&gt;} [nb_tasks])</P><P><BR />I have no idea how to do that ?<BR />Any help welcome.</P> Sat, 16 Nov 2024 02:13:41 GMT bertrand01 2024-11-16T02:13:41Z https://community.qlik.com/t5/App-Development/How-to-get-previous-working-day/m-p/1708482#M54356 <P><BR />Hi everybody,</P><P>I have a calendar table with a flag that indicates working days.</P><P><BR />So in my formule I need to get previous working date (from my calendar if possible), and in another previous previous working day.<BR />Here I do it for previous day (-1) (the vMaxDate is the min between selected date and my max Qvd date) :<BR />sum({1&lt;[Statut]={'LOG'}, Date={$(=$(vMaxDate)-1)}&gt;} [nb_tasks])</P><P><BR />I have no idea how to do that ?<BR />Any help welcome.</P> Sat, 16 Nov 2024 02:13:41 GMT https://community.qlik.com/t5/App-Development/How-to-get-previous-working-day/m-p/1708482#M54356 bertrand01 2024-11-16T02:13:41Z