topic Re: Calculating 3 months average in QlikView https://community.qlik.com/t5/QlikView/Calculating-3-months-average/m-p/626400#M1097618 <HTML><HEAD></HEAD><BODY><P>Can you post sample qvw?</P></BODY></HTML> Thu, 08 May 2014 10:10:02 GMT anbu1984 2014-05-08T10:10:02Z Calculating 3 months average https://community.qlik.com/t5/QlikView/Calculating-3-months-average/m-p/626397#M1097615 <HTML><HEAD></HEAD><BODY><P>I need to calculate average of previous 3 months. When i calculate by using formula (Sum(Rev) Feb + Sum(Rev) Jan + Sum(Rev) Dec) /3 somehow i am not getting correct values. Is this the wrong way to calculate it? as when i take data separately for each month in excel and divide it by 3 it gives different value</P></BODY></HTML> Thu, 08 May 2014 09:49:15 GMT https://community.qlik.com/t5/QlikView/Calculating-3-months-average/m-p/626397#M1097615 rsdhavle 2014-05-08T09:49:15Z Re: Calculating 3 months average https://community.qlik.com/t5/QlikView/Calculating-3-months-average/m-p/626398#M1097616 <HTML><HEAD></HEAD><BODY><P>Try using set analysis.</P><P>Take logic from this thread</P><P><A href="https://community.qlik.com/message/325601">Re: Current Years Current Month Vs Last Year Same Month Sales</A></P></BODY></HTML> Thu, 08 May 2014 09:53:25 GMT https://community.qlik.com/t5/QlikView/Calculating-3-months-average/m-p/626398#M1097616 sujeetsingh 2014-05-08T09:53:25Z Re: Calculating 3 months average https://community.qlik.com/t5/QlikView/Calculating-3-months-average/m-p/626399#M1097617 <HTML><HEAD></HEAD><BODY><P>I have used set analysis in my expression still when i divide it by 3 then the values comes quite diferent</P></BODY></HTML> Thu, 08 May 2014 10:06:49 GMT https://community.qlik.com/t5/QlikView/Calculating-3-months-average/m-p/626399#M1097617 rsdhavle 2014-05-08T10:06:49Z Re: Calculating 3 months average https://community.qlik.com/t5/QlikView/Calculating-3-months-average/m-p/626400#M1097618 <HTML><HEAD></HEAD><BODY><P>Can you post sample qvw?</P></BODY></HTML> Thu, 08 May 2014 10:10:02 GMT https://community.qlik.com/t5/QlikView/Calculating-3-months-average/m-p/626400#M1097618 anbu1984 2014-05-08T10:10:02Z