Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

cancel
Showing results for 
Search instead for 
Did you mean: 
bertrand01
Contributor III
Contributor III

How to get previous working day ?


Hi everybody,

I have a calendar table with a flag that indicates working days.


So in my formule I need to get previous working date (from my calendar if possible), and in another previous previous working day.
Here I do it for previous day (-1) (the vMaxDate is the min between selected date and my max Qvd date) :
sum({1<[Statut]={'LOG'}, Date={$(=$(vMaxDate)-1)}>} [nb_tasks])


I have no idea how to do that ?
Any help welcome.

Labels (2)
0 Replies