topic Re: How to calculate ast 4 Week Average in QlikView https://community.qlik.com/t5/QlikView/How-to-calculate-ast-4-Week-Average/m-p/1071331#M933837 <HTML><HEAD></HEAD><BODY><P>Something like</P><P><EM>Sum({1&lt; DateTest={"&gt;=$(=Date(Today() - 28)) &lt;$(=Today())"}&gt;} [CA])</EM></P></BODY></HTML> Wed, 02 Mar 2016 12:12:14 GMT jonathandienst 2016-03-02T12:12:14Z How to calculate ast 4 Week Average https://community.qlik.com/t5/QlikView/How-to-calculate-ast-4-Week-Average/m-p/1071328#M933834 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I have the following expression in order to calculate&nbsp; CA from the begining of the year till yeasterday</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">=num(Sum({1&lt; DateTest={"$(='&gt;=' &amp; Yearstart(AddYears(Today(), -1)) &amp; '&lt;' &amp;&nbsp; AddYears(Today(), -1))"}&gt;} [CA]&nbsp; ),'# ##0 ;-# ##0 ')</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">How to calculate CA average for the last 4 weeks ?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-ast-4-Week-Average/m-p/1071328#M933834 Anonymous 2020-11-25T16:16:04Z Re: How to calculate ast 4 Week Average https://community.qlik.com/t5/QlikView/How-to-calculate-ast-4-Week-Average/m-p/1071329#M933835 <HTML><HEAD></HEAD><BODY><P>Try to avoid re-posting the same question: <A href="https://community.qlik.com/thread/207795">Calculate an average for the last 4 weeks</A></P></BODY></HTML> Wed, 02 Mar 2016 11:58:12 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-ast-4-Week-Average/m-p/1071329#M933835 sunny_talwar 2016-03-02T11:58:12Z Re: How to calculate ast 4 Week Average https://community.qlik.com/t5/QlikView/How-to-calculate-ast-4-Week-Average/m-p/1071330#M933836 <HTML><HEAD></HEAD><BODY><P>try &gt;= weekstart(today(),-4) in above expression and today() for current date.</P></BODY></HTML> Wed, 02 Mar 2016 12:02:28 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-ast-4-Week-Average/m-p/1071330#M933836 Digvijay_Singh 2016-03-02T12:02:28Z Re: How to calculate ast 4 Week Average https://community.qlik.com/t5/QlikView/How-to-calculate-ast-4-Week-Average/m-p/1071331#M933837 <HTML><HEAD></HEAD><BODY><P>Something like</P><P><EM>Sum({1&lt; DateTest={"&gt;=$(=Date(Today() - 28)) &lt;$(=Today())"}&gt;} [CA])</EM></P></BODY></HTML> Wed, 02 Mar 2016 12:12:14 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-ast-4-Week-Average/m-p/1071331#M933837 jonathandienst 2016-03-02T12:12:14Z