https://community.qlik.com/t5/App-Development/Calculating-weekly-average-for-the-past-month/m-p/1762553#M58994 <P>I'm trying to calculate the previous week's sales vs the weekly average of the past month's sales, i.e. in the past month, what is the average sales for each week.</P><P>I can do the first part, the previous week's sales with&nbsp;<FONT face="batang,apple gothic">=sum({&lt;date= {"&gt;=$(=Date(weekstart(MAX(date)-7)))&lt;$(=Date(weekend(MAX(date)-7)))"}&gt;} Gross_Consideration_Eur ) </FONT></P><P>However, I'm not sure how to get the weekly average of the past month. How can I do this?</P> Wed, 18 Nov 2020 11:52:14 GMT johnnyjohn 2020-11-18T11:52:14Z https://community.qlik.com/t5/App-Development/Calculating-weekly-average-for-the-past-month/m-p/1762553#M58994 <P>I'm trying to calculate the previous week's sales vs the weekly average of the past month's sales, i.e. in the past month, what is the average sales for each week.</P><P>I can do the first part, the previous week's sales with&nbsp;<FONT face="batang,apple gothic">=sum({&lt;date= {"&gt;=$(=Date(weekstart(MAX(date)-7)))&lt;$(=Date(weekend(MAX(date)-7)))"}&gt;} Gross_Consideration_Eur ) </FONT></P><P>However, I'm not sure how to get the weekly average of the past month. How can I do this?</P> Wed, 18 Nov 2020 11:52:14 GMT https://community.qlik.com/t5/App-Development/Calculating-weekly-average-for-the-past-month/m-p/1762553#M58994 johnnyjohn 2020-11-18T11:52:14Z