Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
arvindjha2050
Creator
Creator

Dynamic Yesterday Calculation

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

Labels (1)
3 Replies
JordyWegman
Partner - Master
Partner - Master

Hi,

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

Jordy

Climber

Work smarter, not harder
arvindjha2050
Creator
Creator
Author

Hi,

Which post are you refering to /

Thanks
JordyWegman
Partner - Master
Partner - Master

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

Work smarter, not harder