topic Re: Average in QlikView https://community.qlik.com/t5/QlikView/Average/m-p/350447#M129873 <HTML><HEAD></HEAD><BODY><P>I didnt understand clearly but one of these two might be what you are looking for:</P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_1342205546690359" jivemacro_uid="_1342205546690359"><P>Avg(Total &lt;Product&gt; Expense)</P><P>Avg(Total &lt;Year&gt; Expense)</P></PRE><P></P><P>Regards,</P><P>Kiran Rokkam.</P></BODY></HTML> Fri, 13 Jul 2012 18:51:06 GMT 2012-07-13T18:51:06Z Average https://community.qlik.com/t5/QlikView/Average/m-p/350446#M129872 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>I ahve the following table </P><P>Product&nbsp;&nbsp;&nbsp;&nbsp; Revnue&nbsp;&nbsp;&nbsp;&nbsp; Expense&nbsp;&nbsp;&nbsp;&nbsp; Year</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2008</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.2%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3.6%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2009</P><P>C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.96%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0.46%&nbsp;&nbsp;&nbsp;&nbsp; 2010</P><P></P><P></P><P>How can I calculate the average of a product per year?</P><P>Thxs,</P></BODY></HTML> Fri, 13 Jul 2012 17:55:43 GMT https://community.qlik.com/t5/QlikView/Average/m-p/350446#M129872 alec1982 2012-07-13T17:55:43Z Re: Average https://community.qlik.com/t5/QlikView/Average/m-p/350447#M129873 <HTML><HEAD></HEAD><BODY><P>I didnt understand clearly but one of these two might be what you are looking for:</P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_1342205546690359" jivemacro_uid="_1342205546690359"><P>Avg(Total &lt;Product&gt; Expense)</P><P>Avg(Total &lt;Year&gt; Expense)</P></PRE><P></P><P>Regards,</P><P>Kiran Rokkam.</P></BODY></HTML> Fri, 13 Jul 2012 18:51:06 GMT https://community.qlik.com/t5/QlikView/Average/m-p/350447#M129873 2012-07-13T18:51:06Z