https://community.qlik.com/t5/QlikView/Set-Expression-for-Runnig-Average-by-Quarter/m-p/1608855#M737262 <P>Try&nbsp;</P><P>RangeAvg (Above(MyField,0,3))</P><P>&nbsp;this will give you avg of three months</P><P>RangeAvg (Above(MyField,0,2))</P><P>this will give you abg of two months</P> Fri, 02 Aug 2019 10:22:22 GMT miskinmaz 2019-08-02T10:22:22Z https://community.qlik.com/t5/QlikView/Set-Expression-for-Runnig-Average-by-Quarter/m-p/1606303#M737260 <P>I'm trying to calculate the Running Average by Quarter</P><UL><LI>For the first month of each quarter, the AVG will be the value of that month.</LI><LI>For the second month, the AVG of the 1st and 2nd.</LI><LI>For the third month, the AVG of the three months of that quarter.</LI></UL><P>Example:&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 320px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/16071i499758956225889F/image-size/large?v=v2&amp;px=999" role="button" title="image.png" alt="image.png" /></span></P><P>Already have columns A,B,C, need to calculate D</P><P>Thanks in advance</P><P>Robert</P> Sat, 16 Nov 2024 20:22:53 GMT https://community.qlik.com/t5/QlikView/Set-Expression-for-Runnig-Average-by-Quarter/m-p/1606303#M737260 rfigueroa 2024-11-16T20:22:53Z https://community.qlik.com/t5/QlikView/Set-Expression-for-Runnig-Average-by-Quarter/m-p/1608852#M737261 <P>Hey,</P><P>try rangeavg(above(Avg_Qtr))</P><P>hope it helps.</P> Fri, 02 Aug 2019 10:07:11 GMT https://community.qlik.com/t5/QlikView/Set-Expression-for-Runnig-Average-by-Quarter/m-p/1608852#M737261 madimadi 2019-08-02T10:07:11Z https://community.qlik.com/t5/QlikView/Set-Expression-for-Runnig-Average-by-Quarter/m-p/1608855#M737262 <P>Try&nbsp;</P><P>RangeAvg (Above(MyField,0,3))</P><P>&nbsp;this will give you avg of three months</P><P>RangeAvg (Above(MyField,0,2))</P><P>this will give you abg of two months</P> Fri, 02 Aug 2019 10:22:22 GMT https://community.qlik.com/t5/QlikView/Set-Expression-for-Runnig-Average-by-Quarter/m-p/1608855#M737262 miskinmaz 2019-08-02T10:22:22Z