topic Calculate the last 4 weeks in Expression in QlikView

Calculate the last 4 weeks in Expression

mparker123 — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I am trying to calculate the last 4 weeks from today and have that rolling each day. I do not have a week field but i do have a day, month, and year field. the expression i am currently trying to use is

Sum(If(week(Date(Today()-4)) and DEPT='44840'and epic_status<>'Not Required' and epic_status<>'Done',HOURS)).

This does not seem to work. I was wondering if their was any other expression i could try to accomplish this.

Re: Calculate the last 4 weeks in Expression

MK9885 — Mon, 09 Oct 2017 20:37:55 GMT

Week(YourDatefield) as Week <<<< use this in your scrip.

and in front end...

Maybe something like below?

=sum({<epic_status-={'Not Required'},epic_status-={'Done'},

DEPT={'44840'},Week = {$(=Max(Week-4))}>} YourDimension)

Re: Calculate the last 4 weeks in Expression

Clever_Anjos — Mon, 09 Oct 2017 20:54:32 GMT

week(Date(Today()-4)) should be week(Today()-4*7)

Re: Calculate the last 4 weeks in Expression

vikasdesai — Tue, 10 Oct 2017 11:43:45 GMT

Hello Friend

Please use Following Expression,

Sum({<Date={">=$(=Weekstart(max(Date),-3))<=$(=max(Date))"},Year=,Month=>} Hours)

Regards

Vikas

Re: Calculate the last 4 weeks in Expression

Clever_Anjos — Tue, 10 Oct 2017 14:05:44 GMT

Did this solve your needs?

If yes, please kindly close this thread