topic Average Calculation in QlikView https://community.qlik.com/t5/QlikView/Average-Calculation/m-p/1065380#M356235 <HTML><HEAD></HEAD><BODY><P>Hi Friends</P><P></P><P>In my QV document I have created following pivot table</P><P></P><TABLE><TBODY><TR><TD>PERIOD</TD><TD>2012</TD><TD>2013</TD><TD>2014</TD><TD>2015</TD></TR><TR><TD>MAY-JUN-JUL</TD><TD>17,954,582</TD><TD>18,362,554</TD><TD>24,091,463</TD><TD>16,047,949</TD></TR><TR><TD>OTHER- 9 MONTHS</TD><TD>68,782,229</TD><TD>49,225,098</TD><TD>67,029,590</TD><TD>50,529,104</TD></TR><TR><TD>TOTAL</TD><TD> 86,736,810</TD><TD> 67,587,652</TD><TD> 91,121,053</TD><TD> 66,577,052 </TD></TR></TBODY></TABLE><P></P><P> I want to calculate month average of above figures depending on number of month&nbsp; as per example given below</P><P></P><TABLE><TBODY><TR><TD>PERIOD</TD><TD>2012</TD><TD>Average</TD><TD></TD></TR><TR><TD>MAY-JUN-JUL</TD><TD>17,954,582</TD><TD>5,984,861</TD><TD>(17954582/3)</TD></TR><TR><TD>OTHER- 9 MONTHS</TD><TD>68,782,229</TD><TD>7,642,470</TD><TD>(68782229/9)</TD></TR><TR><TD>TOTAL</TD><TD> 86,736,810</TD><TD> 7,228,068</TD><TD> (86736810/12) </TD></TR></TBODY></TABLE><P></P><P>Could you please help me do it in another column of Pivot table itself</P></BODY></HTML> Sun, 07 Feb 2016 04:41:37 GMT upaliwije 2016-02-07T04:41:37Z Average Calculation https://community.qlik.com/t5/QlikView/Average-Calculation/m-p/1065380#M356235 <HTML><HEAD></HEAD><BODY><P>Hi Friends</P><P></P><P>In my QV document I have created following pivot table</P><P></P><TABLE><TBODY><TR><TD>PERIOD</TD><TD>2012</TD><TD>2013</TD><TD>2014</TD><TD>2015</TD></TR><TR><TD>MAY-JUN-JUL</TD><TD>17,954,582</TD><TD>18,362,554</TD><TD>24,091,463</TD><TD>16,047,949</TD></TR><TR><TD>OTHER- 9 MONTHS</TD><TD>68,782,229</TD><TD>49,225,098</TD><TD>67,029,590</TD><TD>50,529,104</TD></TR><TR><TD>TOTAL</TD><TD> 86,736,810</TD><TD> 67,587,652</TD><TD> 91,121,053</TD><TD> 66,577,052 </TD></TR></TBODY></TABLE><P></P><P> I want to calculate month average of above figures depending on number of month&nbsp; as per example given below</P><P></P><TABLE><TBODY><TR><TD>PERIOD</TD><TD>2012</TD><TD>Average</TD><TD></TD></TR><TR><TD>MAY-JUN-JUL</TD><TD>17,954,582</TD><TD>5,984,861</TD><TD>(17954582/3)</TD></TR><TR><TD>OTHER- 9 MONTHS</TD><TD>68,782,229</TD><TD>7,642,470</TD><TD>(68782229/9)</TD></TR><TR><TD>TOTAL</TD><TD> 86,736,810</TD><TD> 7,228,068</TD><TD> (86736810/12) </TD></TR></TBODY></TABLE><P></P><P>Could you please help me do it in another column of Pivot table itself</P></BODY></HTML> Sun, 07 Feb 2016 04:41:37 GMT https://community.qlik.com/t5/QlikView/Average-Calculation/m-p/1065380#M356235 upaliwije 2016-02-07T04:41:37Z Re: Average Calculation https://community.qlik.com/t5/QlikView/Average-Calculation/m-p/1065381#M356236 <HTML><HEAD></HEAD><BODY><P>Provide sample data or sample app...</P></BODY></HTML> Sun, 07 Feb 2016 08:27:41 GMT https://community.qlik.com/t5/QlikView/Average-Calculation/m-p/1065381#M356236 MK_QSL 2016-02-07T08:27:41Z Re: Average Calculation https://community.qlik.com/t5/QlikView/Average-Calculation/m-p/1065382#M356237 <HTML><HEAD></HEAD><BODY><P>APPLICATION ATTACHED HEREWITH PLS !</P></BODY></HTML> Sun, 07 Feb 2016 08:35:30 GMT https://community.qlik.com/t5/QlikView/Average-Calculation/m-p/1065382#M356237 upaliwije 2016-02-07T08:35:30Z Re: Average Calculation https://community.qlik.com/t5/QlikView/Average-Calculation/m-p/1065383#M356238 <HTML><HEAD></HEAD><BODY><P>for average use below expression</P><P>SUM(CRE_PAID_AMOUNT)/COUNT(DISTINCT PAID_MONTH)</P></BODY></HTML> Sun, 07 Feb 2016 08:39:46 GMT https://community.qlik.com/t5/QlikView/Average-Calculation/m-p/1065383#M356238 MK_QSL 2016-02-07T08:39:46Z Re: Average Calculation https://community.qlik.com/t5/QlikView/Average-Calculation/m-p/1065384#M356239 <HTML><HEAD></HEAD><BODY><P>thanks a lot</P></BODY></HTML> Sun, 07 Feb 2016 08:54:15 GMT https://community.qlik.com/t5/QlikView/Average-Calculation/m-p/1065384#M356239 upaliwije 2016-02-07T08:54:15Z