topic Re: Average Calculation in QlikView https://community.qlik.com/t5/QlikView/Average-Calculation/m-p/365365#M135981 <HTML><HEAD></HEAD><BODY><P>Try:</P><P></P><P>Avg(TOTAL &lt;[Marketing Group],[Marketing Team]&gt; [Working Days])</P><P></P><P>Hope this helps,</P><P></P><P>Jason</P></BODY></HTML> Sat, 23 Jun 2012 16:04:05 GMT Jason_Michaelides 2012-06-23T16:04:05Z Average Calculation https://community.qlik.com/t5/QlikView/Average-Calculation/m-p/365364#M135980 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>How to calculate the average in the pivot table and the straight table.</P><P></P><P>Consider i have below table.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="471"><TBODY><TR><TD height="20" width="101">Marketing Group</TD><TD width="108">Marketing Team</TD><TD width="78">Location</TD><TD width="92">Month</TD><TD width="92">Working Days</TD></TR><TR><TD height="20">A</TD><TD>A1</TD><TD>New York</TD><TD align="right" class="xl63">Jan-11</TD><TD align="right">20</TD></TR><TR><TD height="20">A</TD><TD>A1</TD><TD>New York</TD><TD align="right" class="xl63">Feb-11</TD><TD align="right">18</TD></TR><TR><TD height="20">A</TD><TD>A1</TD><TD>New Jersey</TD><TD align="right" class="xl63">Jan-11</TD><TD align="right">20</TD></TR><TR><TD height="20">A</TD><TD>A1</TD><TD>New Jersey</TD><TD align="right" class="xl63">Feb-11</TD><TD align="right">18</TD></TR><TR><TD height="20">A</TD><TD>A2</TD></TR><TR><TD height="20">A</TD><TD>A3</TD></TR><TR><TD height="20">B</TD><TD>B1</TD><TD>DC</TD><TD align="right" class="xl63">Jan-11</TD><TD align="right">20</TD></TR><TR><TD height="20">B</TD><TD>B2</TD></TR><TR><TD height="20">B</TD><TD>B3</TD></TR></TBODY></TABLE><P></P><P>there are marketing team without location but active so i want to show only the Maketing Group and Marketing Team Which is having location&nbsp; and average of working days. i tried to use Avg but it is giving wrong value.&nbsp; </P><P></P><P>Considering the avg calculation&nbsp; is A= 76/2= 38, but it is taking the avg by location and taking the avg og Marketing team. But it should be sum of Location and avg at marketing team</P></BODY></HTML> Sat, 23 Jun 2012 14:36:11 GMT https://community.qlik.com/t5/QlikView/Average-Calculation/m-p/365364#M135980 brindlogcool 2012-06-23T14:36:11Z Re: Average Calculation https://community.qlik.com/t5/QlikView/Average-Calculation/m-p/365365#M135981 <HTML><HEAD></HEAD><BODY><P>Try:</P><P></P><P>Avg(TOTAL &lt;[Marketing Group],[Marketing Team]&gt; [Working Days])</P><P></P><P>Hope this helps,</P><P></P><P>Jason</P></BODY></HTML> Sat, 23 Jun 2012 16:04:05 GMT https://community.qlik.com/t5/QlikView/Average-Calculation/m-p/365365#M135981 Jason_Michaelides 2012-06-23T16:04:05Z