topic Average trendline in QlikView https://community.qlik.com/t5/QlikView/Average-trendline/m-p/513566#M191915 <HTML><HEAD></HEAD><BODY><P>I am trying to show an average trendline on a column chart of weekly opened cases (I have a single dimension <SPAN style="color: #800000; font-family: Arial, sans-serif; font-size: 12px;">Open.WeekYr</SPAN>) . When I try to calculate the same value using the expression <SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">=</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: blue;">avg</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">(</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: blue;">aggr</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">(</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: blue;">sum</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">(</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: maroon;">#Cases</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">),</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: maroon;">Open.WeekYr</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">)) I get a different value.</SPAN></P><P></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">Any ideas?</SPAN></P></BODY></HTML> Fri, 20 Dec 2013 11:29:21 GMT DavidFoster1 2013-12-20T11:29:21Z Average trendline https://community.qlik.com/t5/QlikView/Average-trendline/m-p/513566#M191915 <HTML><HEAD></HEAD><BODY><P>I am trying to show an average trendline on a column chart of weekly opened cases (I have a single dimension <SPAN style="color: #800000; font-family: Arial, sans-serif; font-size: 12px;">Open.WeekYr</SPAN>) . When I try to calculate the same value using the expression <SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">=</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: blue;">avg</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">(</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: blue;">aggr</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">(</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: blue;">sum</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">(</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: maroon;">#Cases</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">),</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: maroon;">Open.WeekYr</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">)) I get a different value.</SPAN></P><P></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">Any ideas?</SPAN></P></BODY></HTML> Fri, 20 Dec 2013 11:29:21 GMT https://community.qlik.com/t5/QlikView/Average-trendline/m-p/513566#M191915 DavidFoster1 2013-12-20T11:29:21Z Re: Average trendline https://community.qlik.com/t5/QlikView/Average-trendline/m-p/513567#M191916 <HTML><HEAD></HEAD><BODY><P>Hi, David</P><P>According to my understanding about Aggr function, you dont need it in one dimensional chart.</P><P>i think =sum(sale) and aggr(sum(sale)) will give you same result, if you have one dimension.</P><P></P><P>so in your scenario, you dont need aggr function, simply, avg(#Cases) will give you result.</P><P></P><P>kindly correct me if i am wrong...</P></BODY></HTML> Fri, 20 Dec 2013 11:52:12 GMT https://community.qlik.com/t5/QlikView/Average-trendline/m-p/513567#M191916 israrkhan 2013-12-20T11:52:12Z Re: Average trendline https://community.qlik.com/t5/QlikView/Average-trendline/m-p/513568#M191917 <HTML><HEAD></HEAD><BODY><P>Sorry for the confusion. </P><P></P><P>The aggr statement is in a separate text box.</P></BODY></HTML> Fri, 20 Dec 2013 11:54:29 GMT https://community.qlik.com/t5/QlikView/Average-trendline/m-p/513568#M191917 DavidFoster1 2013-12-20T11:54:29Z