Qlik Community

Qlik Sense App Development

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

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

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 (2)
3 Replies
Highlighted
Partner
Partner

Hi,

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

Jordy

Climber

Work smarter, not harder
Highlighted
Contributor III
Contributor III

Hi,

Which post are you refering to /

Thanks
Highlighted
Partner
Partner

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