Discussion board where members can learn more about Qlik Sense App Development and Usage.
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,
Check this post and use then the max(Date) where Workday = 1.
I see that the link didn't work: