topic rolling 3 month accumulation in QlikView https://community.qlik.com/t5/QlikView/rolling-3-month-accumulation/m-p/818212#M288475 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>I have a scenario for rolling 12 month in my project . Please see the data below :</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 334px;"><TBODY><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="height: 12.75pt; width: 50pt;" width="66"><IMG class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/79680_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" /></TD><TD class="xl63" style="border-left: none; width: 56pt;" width="75"></TD><TD class="xl63" style="border-left: none; width: 47pt;" width="62"></TD><TD class="xl63" style="border-left: none; width: 45pt;" width="60"></TD><TD class="xl63" style="border-left: none; width: 53pt;" width="71"></TD></TR></TBODY></TABLE><P></P><P>Process node can have multiple fabs. Requirement is to accumulate the sample size and failures by FAB for each process node( above data has only one process node)&nbsp; . Accumulation should happen for 3 months. These accumulated values need to be used in one more column.. please suggest a solution.. </P></BODY></HTML> Mon, 02 Mar 2015 21:57:19 GMT 2015-03-02T21:57:19Z rolling 3 month accumulation https://community.qlik.com/t5/QlikView/rolling-3-month-accumulation/m-p/818212#M288475 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>I have a scenario for rolling 12 month in my project . Please see the data below :</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 334px;"><TBODY><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="height: 12.75pt; width: 50pt;" width="66"><IMG class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/79680_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" /></TD><TD class="xl63" style="border-left: none; width: 56pt;" width="75"></TD><TD class="xl63" style="border-left: none; width: 47pt;" width="62"></TD><TD class="xl63" style="border-left: none; width: 45pt;" width="60"></TD><TD class="xl63" style="border-left: none; width: 53pt;" width="71"></TD></TR></TBODY></TABLE><P></P><P>Process node can have multiple fabs. Requirement is to accumulate the sample size and failures by FAB for each process node( above data has only one process node)&nbsp; . Accumulation should happen for 3 months. These accumulated values need to be used in one more column.. please suggest a solution.. </P></BODY></HTML> Mon, 02 Mar 2015 21:57:19 GMT https://community.qlik.com/t5/QlikView/rolling-3-month-accumulation/m-p/818212#M288475 2015-03-02T21:57:19Z Re: rolling 3 month accumulation https://community.qlik.com/t5/QlikView/rolling-3-month-accumulation/m-p/818213#M288476 <HTML><HEAD></HEAD><BODY><P>See this document: <A _jive_internal="true" href="https://community.qlik.com/docs/DOC-4252" style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3778c7;">Calculating rolling n-period totals, averages or other aggregations</A></P></BODY></HTML> Tue, 03 Mar 2015 09:31:37 GMT https://community.qlik.com/t5/QlikView/rolling-3-month-accumulation/m-p/818213#M288476 Gysbert_Wassenaar 2015-03-03T09:31:37Z