topic Re: Dynamic Yesterday Calculation in App Development

Dynamic Yesterday Calculation

arvindjha2050 — Sat, 16 Nov 2024 05:22:29 GMT

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

Re: Dynamic Yesterday Calculation

JordyWegman — Mon, 08 Jul 2019 12:32:04 GMT

Hi,

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

Jordy

Climber

Re: Dynamic Yesterday Calculation

arvindjha2050 — Mon, 08 Jul 2019 16:37:43 GMT

Hi,

Which post are you refering to /

Thanks

Re: Dynamic Yesterday Calculation

JordyWegman — Tue, 09 Jul 2019 06:43:33 GMT

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#M43207

Jordy

Climber