Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
arvindjha2050
Creator
Creator

Calculation of Dynamic Previous Day

Hello Team,

I need to calculate dynamic previous day based on below logic :

 

For Tuesday to Friday it will be previous day.

For Monday it will be Friday.But if Friday is Holiday it should be Thursday.

 

How to accomplish that?

 

Thanks

Labels (1)
1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try like:

 

=FirstWorkDate(Today(), , <holiday list>)

View solution in original post

1 Reply
tresesco
MVP
MVP

Try like:

 

=FirstWorkDate(Today(), , <holiday list>)