topic How to get monthly average sales per product? in QlikView https://community.qlik.com/t5/QlikView/How-to-get-monthly-average-sales-per-product/m-p/14378#M783156 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>I'm creating a chart which displays the monthly average sales per product however I have a daily data set in Excel.</P><P></P><P><IMG __jive_id="197554" alt="1.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/197554_1.PNG" style="height: auto;" /></P><P></P><P>In the Expressions tab, I used this expression: =Avg(Aggr(Sum(Sales),Date,Product)) and upon applying, chart looked like this</P><P></P><P><IMG __jive_id="197555" alt="2.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/197555_2.PNG" style="height: auto;" /></P><P>The scale was a lot smaller since I have data set in daily format but what I need is the monthly averages.</P><P>I've also tried editing the Script using the MonthStart string to no avail. Hope someone can help me on this.</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z How to get monthly average sales per product? https://community.qlik.com/t5/QlikView/How-to-get-monthly-average-sales-per-product/m-p/14378#M783156 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>I'm creating a chart which displays the monthly average sales per product however I have a daily data set in Excel.</P><P></P><P><IMG __jive_id="197554" alt="1.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/197554_1.PNG" style="height: auto;" /></P><P></P><P>In the Expressions tab, I used this expression: =Avg(Aggr(Sum(Sales),Date,Product)) and upon applying, chart looked like this</P><P></P><P><IMG __jive_id="197555" alt="2.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/197555_2.PNG" style="height: auto;" /></P><P>The scale was a lot smaller since I have data set in daily format but what I need is the monthly averages.</P><P>I've also tried editing the Script using the MonthStart string to no avail. Hope someone can help me on this.</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-get-monthly-average-sales-per-product/m-p/14378#M783156 Anonymous 2020-11-25T16:16:04Z Re: How to get monthly average sales per product? https://community.qlik.com/t5/QlikView/How-to-get-monthly-average-sales-per-product/m-p/14379#M783160 <HTML><HEAD></HEAD><BODY><P>Have you tried this?</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>=Avg(Aggr(Sum(Sales),MonthYear,Product))</STRONG></SPAN></P><P></P><P>Where MonthYear is calculated in the script like this</P><P><STRONG>Date(MonthStart(Date), 'MMM-YYYY') as MonthYear</STRONG></P></BODY></HTML> Tue, 27 Mar 2018 14:04:18 GMT https://community.qlik.com/t5/QlikView/How-to-get-monthly-average-sales-per-product/m-p/14379#M783160 sunny_talwar 2018-03-27T14:04:18Z Re: How to get monthly average sales per product? https://community.qlik.com/t5/QlikView/How-to-get-monthly-average-sales-per-product/m-p/14380#M783163 <HTML><HEAD></HEAD><BODY><P>I did it! Thanks for the help!</P></BODY></HTML> Mon, 02 Apr 2018 02:30:14 GMT https://community.qlik.com/t5/QlikView/How-to-get-monthly-average-sales-per-product/m-p/14380#M783163 Anonymous 2018-04-02T02:30:14Z