topic Re: Getting max(Date)-7 without including weekends in QlikView

Getting max(Date)-7 without including weekends

Manish — Tue, 28 Jun 2022 16:18:13 GMT

Hi Guys

I have a requirement where I need to find out (Max(Date) -7) but without considering the weekends.

For example if Max(Date) = 27th Jun 2022 then in that case (Max(Date)-7) should be "17th Jun 2022" and not "21st Jun 2022".

I want to do this in front end.

I would really appreciate a response.

sidhiq91 — Tue, 28 Jun 2022 17:54:16 GMT

@Manish Please use something like below expression

NetWorkDays(Today()-7,today())

Or In your Case I have created 2 Variables: Vstartdate=Max(Date)

V7DaysPrior=Max(Date)-7

Final Expression would be :NetWorkDays($(V7DaysPrior),$(Vstartdate))

TiagoCardoso — Tue, 28 Jun 2022 18:06:46 GMT

Hi.

Maybe this helps you.

Sample Date generation from Today -1 to past 100 days:

a: LOAD Date(Today()-1-RowNo()+1) AS Date AUTOGENERATE 100;

Expression used to desconsider the non working days:

DATE(Max({<Date-={"=MATCH(WeekDay(Date)*1,0,6)"}>} Date,7))

Result: