Dynamic Yesterday Calculation

[arvindjha2050]

Hello all,

This is regarding dynamic calculation for yesterday.

I need to calculate metrics based on condition Today() - 1 but need to exclude Saturdays,Sundays and also holidays which are different for different countries.

For example on Monday T-1 will be last Friday but if Friday is holiday it has to be Thursday.

I tried NetworkDays but here Min Date is dynamic.

Thanks & Regards,

Arvind Jha

[JordyWegman]

Hi,

Check this post and use then the max(Date) where Workday = 1.

Jordy

Climber

[arvindjha2050]

Hi,

Which post are you refering to /

Thanks

[JordyWegman]

I see that the link didn't work:

https://community.qlik.com/t5/Qlik-Sense-App-Development/Count-Days-If-Working-Day/m-p/1589396#M4320...

Jordy

Climber