topic Aggregate Function with Trends in QlikView https://community.qlik.com/t5/QlikView/Aggregate-Function-with-Trends/m-p/59446#M770794 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I would like to create a chart with Monthly Trends and the calculation requires and Aggregate function to return desired results.</P><P>I want to view months before and including selected months, however as soon as I use aggr() in the expression, this capability is broken and I only see the selected month. Is there a way to do this without having to aggregate data in the back end?</P><P></P><P>Please see attached qvw</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Aggregate Function with Trends https://community.qlik.com/t5/QlikView/Aggregate-Function-with-Trends/m-p/59446#M770794 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I would like to create a chart with Monthly Trends and the calculation requires and Aggregate function to return desired results.</P><P>I want to view months before and including selected months, however as soon as I use aggr() in the expression, this capability is broken and I only see the selected month. Is there a way to do this without having to aggregate data in the back end?</P><P></P><P>Please see attached qvw</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Aggregate-Function-with-Trends/m-p/59446#M770794 Anonymous 2020-11-25T16:16:04Z Re: Aggregate Function with Trends https://community.qlik.com/t5/QlikView/Aggregate-Function-with-Trends/m-p/59447#M770795 <HTML><HEAD></HEAD><BODY><P>Apply the inner aggregation set analysis to the outer aggregation also to fix this issue</P><P></P><P><STRONG>Avg(<SPAN style="color: #ff0000;">{&lt;Month={"&lt;=$(vMaxMonth)"}&gt;}</SPAN> Aggr(Avg({&lt;Month={"&lt;=$(vMaxMonth)"}&gt;}Sales),Month,Company))</STRONG></P></BODY></HTML> Tue, 05 Jun 2018 15:00:25 GMT https://community.qlik.com/t5/QlikView/Aggregate-Function-with-Trends/m-p/59447#M770795 sunny_talwar 2018-06-05T15:00:25Z Re: Aggregate Function with Trends https://community.qlik.com/t5/QlikView/Aggregate-Function-with-Trends/m-p/59448#M770796 <HTML><HEAD></HEAD><BODY><P>Hi Sunny</P><P></P><P>Thanks for your reply, It works perfectly <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 05 Jun 2018 18:55:19 GMT https://community.qlik.com/t5/QlikView/Aggregate-Function-with-Trends/m-p/59448#M770796 Anonymous 2018-06-05T18:55:19Z