topic Re: Average Requirement in QlikView https://community.qlik.com/t5/QlikView/Average-Requirement/m-p/659368#M240536 <HTML><HEAD></HEAD><BODY><P>Actually the expression is same,</P><P>Similarly I am having 12 Months and 6 Months column also available.....</P><P></P><P>fabs(sum(Data)-Sum(Forecast_Data_30))/sum(Data)</P><P></P><P>fabs(sum(Data)-Sum(Forecast_Data_60))/sum(Data)</P><P></P><P>fabs(sum(Data)-Sum(Forecast_Data_90))/sum(Data)</P><P></P><P>fabs(sum(Data)-Sum(Forecast_Data_120))/sum(Data)</P></BODY></HTML> Sun, 27 Jul 2014 20:28:05 GMT Anonymous 2014-07-27T20:28:05Z Average Requirement https://community.qlik.com/t5/QlikView/Average-Requirement/m-p/659366#M240534 <HTML><HEAD></HEAD><BODY><P><IMG alt="Capture.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/63183_Capture.PNG.png" /></P><P></P><P>I have calculated the data as above, but I require average in 3 Months column of all other columns,</P><P></P><P>The green one is required result .</P><P>Please anyone help</P></BODY></HTML> Sun, 27 Jul 2014 20:07:45 GMT https://community.qlik.com/t5/QlikView/Average-Requirement/m-p/659366#M240534 Anonymous 2014-07-27T20:07:45Z Re: Average Requirement https://community.qlik.com/t5/QlikView/Average-Requirement/m-p/659367#M240535 <HTML><HEAD></HEAD><BODY><P>Did you try Avg function with </P><P></P><P>=AVG(Expression of Aug-14 + Expression of Jul-14 + Expression of Jun-14)</P></BODY></HTML> Sun, 27 Jul 2014 20:14:40 GMT https://community.qlik.com/t5/QlikView/Average-Requirement/m-p/659367#M240535 its_anandrjs 2014-07-27T20:14:40Z Re: Average Requirement https://community.qlik.com/t5/QlikView/Average-Requirement/m-p/659368#M240536 <HTML><HEAD></HEAD><BODY><P>Actually the expression is same,</P><P>Similarly I am having 12 Months and 6 Months column also available.....</P><P></P><P>fabs(sum(Data)-Sum(Forecast_Data_30))/sum(Data)</P><P></P><P>fabs(sum(Data)-Sum(Forecast_Data_60))/sum(Data)</P><P></P><P>fabs(sum(Data)-Sum(Forecast_Data_90))/sum(Data)</P><P></P><P>fabs(sum(Data)-Sum(Forecast_Data_120))/sum(Data)</P></BODY></HTML> Sun, 27 Jul 2014 20:28:05 GMT https://community.qlik.com/t5/QlikView/Average-Requirement/m-p/659368#M240536 Anonymous 2014-07-27T20:28:05Z