topic Script calculation, Charting rolling months, average calculation in QlikView https://community.qlik.com/t5/QlikView/Script-calculation-Charting-rolling-months-average-calculation/m-p/1192714#M628966 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a need to create a bar chart which will display the past 12 months including the current month with some calculations.</P><P>Rolling 12 months formula is available in plenty across the community, but my problem is calculating the average of a particular column from previous year. I have attached an excel which covers all the details, let me know if you need more information.</P><P>Thanks.</P></BODY></HTML> Thu, 29 Sep 2016 08:15:39 GMT 2016-09-29T08:15:39Z Script calculation, Charting rolling months, average calculation https://community.qlik.com/t5/QlikView/Script-calculation-Charting-rolling-months-average-calculation/m-p/1192714#M628966 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a need to create a bar chart which will display the past 12 months including the current month with some calculations.</P><P>Rolling 12 months formula is available in plenty across the community, but my problem is calculating the average of a particular column from previous year. I have attached an excel which covers all the details, let me know if you need more information.</P><P>Thanks.</P></BODY></HTML> Thu, 29 Sep 2016 08:15:39 GMT https://community.qlik.com/t5/QlikView/Script-calculation-Charting-rolling-months-average-calculation/m-p/1192714#M628966 2016-09-29T08:15:39Z Re: Script calculation, Charting rolling months, average calculation https://community.qlik.com/t5/QlikView/Script-calculation-Charting-rolling-months-average-calculation/m-p/1192715#M628967 <HTML><HEAD></HEAD><BODY><P>Is this a different question than what you have asked here: <A href="https://community.qlik.com/thread/234705">Rolling Sum/Rolling Average at Script</A></P></BODY></HTML> Thu, 29 Sep 2016 18:26:50 GMT https://community.qlik.com/t5/QlikView/Script-calculation-Charting-rolling-months-average-calculation/m-p/1192715#M628967 sunny_talwar 2016-09-29T18:26:50Z Re: Script calculation, Charting rolling months, average calculation https://community.qlik.com/t5/QlikView/Script-calculation-Charting-rolling-months-average-calculation/m-p/1192716#M628968 <HTML><HEAD></HEAD><BODY><P>Yes this is the actual question, and the other question is a part of it. Please give me your suggestions on this.</P></BODY></HTML> Fri, 30 Sep 2016 12:08:30 GMT https://community.qlik.com/t5/QlikView/Script-calculation-Charting-rolling-months-average-calculation/m-p/1192716#M628968 2016-09-30T12:08:30Z Re: Script calculation, Charting rolling months, average calculation https://community.qlik.com/t5/QlikView/Script-calculation-Charting-rolling-months-average-calculation/m-p/1192717#M628969 <HTML><HEAD></HEAD><BODY><P>Any suggestions?</P></BODY></HTML> Fri, 30 Sep 2016 14:08:21 GMT https://community.qlik.com/t5/QlikView/Script-calculation-Charting-rolling-months-average-calculation/m-p/1192717#M628969 2016-09-30T14:08:21Z Re: Script calculation, Charting rolling months, average calculation https://community.qlik.com/t5/QlikView/Script-calculation-Charting-rolling-months-average-calculation/m-p/1192718#M628970 <HTML><HEAD></HEAD><BODY><P>Is there a way to pick only the last value of every month? Fisc_Day_Of_Mth_Nbr is the month days column for me.</P><P></P><P></P><P></P><P><IMG alt="Avg.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/139306_Avg.JPG" style="height: auto;" /></P></BODY></HTML> Fri, 30 Sep 2016 16:25:55 GMT https://community.qlik.com/t5/QlikView/Script-calculation-Charting-rolling-months-average-calculation/m-p/1192718#M628970 2016-09-30T16:25:55Z