topic Linear Chart with average in each point in QlikView https://community.qlik.com/t5/QlikView/Linear-Chart-with-average-in-each-point/m-p/623269#M545071 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>i have the linear chart attached below, with two dimension (a temporal one and another one) and i would like to calculate and to show the average value for each temporal unit (in this case day).</P><P></P><P>Can you please help me?</P><P>i attached also an example..</P><P>Thanks</P></BODY></HTML> Thu, 10 Apr 2014 09:06:35 GMT 2014-04-10T09:06:35Z Linear Chart with average in each point https://community.qlik.com/t5/QlikView/Linear-Chart-with-average-in-each-point/m-p/623269#M545071 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>i have the linear chart attached below, with two dimension (a temporal one and another one) and i would like to calculate and to show the average value for each temporal unit (in this case day).</P><P></P><P>Can you please help me?</P><P>i attached also an example..</P><P>Thanks</P></BODY></HTML> Thu, 10 Apr 2014 09:06:35 GMT https://community.qlik.com/t5/QlikView/Linear-Chart-with-average-in-each-point/m-p/623269#M545071 2014-04-10T09:06:35Z Re: Linear Chart with average in each point https://community.qlik.com/t5/QlikView/Linear-Chart-with-average-in-each-point/m-p/623270#M545072 <HTML><HEAD></HEAD><BODY><P>try</P><P></P><P><SPAN style="font-size: 8pt;">=avg</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">count_eop</SPAN><SPAN style="font-size: 8pt;">),</SPAN><SPAN style="color: #800000; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;">)) </SPAN></P><P> </P><P><SPAN style="font-size: 8pt;">Richard</SPAN></P><P><SPAN style="font-size: 8pt;">QlikCentral.com</SPAN></P><P></P></BODY></HTML> Thu, 10 Apr 2014 09:35:43 GMT https://community.qlik.com/t5/QlikView/Linear-Chart-with-average-in-each-point/m-p/623270#M545072 richard_pearce6 2014-04-10T09:35:43Z Re: Linear Chart with average in each point https://community.qlik.com/t5/QlikView/Linear-Chart-with-average-in-each-point/m-p/623271#M545073 <HTML><HEAD></HEAD><BODY><P>Maybe this way?</P><P></P><P>let me know if it helps.</P><P></P><P>regards</P><P>Darek</P></BODY></HTML> Thu, 10 Apr 2014 12:32:38 GMT https://community.qlik.com/t5/QlikView/Linear-Chart-with-average-in-each-point/m-p/623271#M545073 2014-04-10T12:32:38Z