topic Latest three months Average with the entry of January in QlikView https://community.qlik.com/t5/QlikView/Latest-three-months-Average-with-the-entry-of-January/m-p/47287#M7877 <HTML><HEAD></HEAD><BODY><P>Hi, Dear All</P><P></P><P>Please refer the data loaded where I need to calculate averages on four variables over latest three Months (January,December &amp; November). But the results produce for (July to January), But Up to December, with the expression used here always given the averages over three Months. Can some body to look in to this &amp; see what changes to be made to get the required output.</P><P></P><P>Thanks</P><P></P><P>Neville</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/195270_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Sun, 04 Mar 2018 17:46:27 GMT nevilledhamsiri 2018-03-04T17:46:27Z Latest three months Average with the entry of January https://community.qlik.com/t5/QlikView/Latest-three-months-Average-with-the-entry-of-January/m-p/47287#M7877 <HTML><HEAD></HEAD><BODY><P>Hi, Dear All</P><P></P><P>Please refer the data loaded where I need to calculate averages on four variables over latest three Months (January,December &amp; November). But the results produce for (July to January), But Up to December, with the expression used here always given the averages over three Months. Can some body to look in to this &amp; see what changes to be made to get the required output.</P><P></P><P>Thanks</P><P></P><P>Neville</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/195270_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Sun, 04 Mar 2018 17:46:27 GMT https://community.qlik.com/t5/QlikView/Latest-three-months-Average-with-the-entry-of-January/m-p/47287#M7877 nevilledhamsiri 2018-03-04T17:46:27Z