topic 12-month accumulation / How to? in QlikView https://community.qlik.com/t5/QlikView/12-month-accumulation-How-to/m-p/221813#M74584 <HTML><HEAD></HEAD><BODY><P>Hi Tyson,</P><P>was it the value vPeriod in Vaiablelist ?</P><P>do you have any QVD exampel for that?</P><P>Thanks.</P><P></P><P></P></BODY></HTML> Thu, 22 Oct 2009 15:37:32 GMT 2009-10-22T15:37:32Z 12-month accumulation / How to? https://community.qlik.com/t5/QlikView/12-month-accumulation-How-to/m-p/221811#M74582 <HTML><HEAD></HEAD><BODY><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-518_sourceID:518" /></P><P>I have found some examples like YTD, therefore none of 12-month accumulation.</P><P>Per example, in filed Jun 2008 the sum would be "Jun08+May08+Apr08+Mar08+Feb08+Jan08+Dec07+Nov07+Oct07+Sep07+Aug07+Jul07".</P><P>Thank you!</P><P></P><P></P><P></P></BODY></HTML> Wed, 21 Oct 2009 23:24:12 GMT https://community.qlik.com/t5/QlikView/12-month-accumulation-How-to/m-p/221811#M74582 2009-10-21T23:24:12Z 12-month accumulation / How to? https://community.qlik.com/t5/QlikView/12-month-accumulation-How-to/m-p/221812#M74583 <HTML><HEAD></HEAD><BODY><P>aletrindad -</P><P>You can create your rolling 12 month accumulation by using this formula</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />sum(if(inyear(MonthYear, $(vPeriod), 0, month(addmonths($(vPeriod), -11))), Failures))<BR /></PRE></BLOCKQUOTE><BR /><BR /> <P>In the code above you will need to set the vPeriod variable [Settings &gt; Variable Overview &gt; Add]</P><P>Hope this helps.</P><P></P><P>Tyson</P></BODY></HTML> Thu, 22 Oct 2009 04:25:20 GMT https://community.qlik.com/t5/QlikView/12-month-accumulation-How-to/m-p/221812#M74583 2009-10-22T04:25:20Z 12-month accumulation / How to? https://community.qlik.com/t5/QlikView/12-month-accumulation-How-to/m-p/221813#M74584 <HTML><HEAD></HEAD><BODY><P>Hi Tyson,</P><P>was it the value vPeriod in Vaiablelist ?</P><P>do you have any QVD exampel for that?</P><P>Thanks.</P><P></P><P></P></BODY></HTML> Thu, 22 Oct 2009 15:37:32 GMT https://community.qlik.com/t5/QlikView/12-month-accumulation-How-to/m-p/221813#M74584 2009-10-22T15:37:32Z 12-month accumulation / How to? https://community.qlik.com/t5/QlikView/12-month-accumulation-How-to/m-p/221814#M74585 <HTML><HEAD></HEAD><BODY><P>Hi <STRONG>Tyson!</STRONG></P><P>I didn't understand the Variable vPeriod and also the relation between MonthYear and the Variable into inyear function.</P><P>I would be very gratefull, if you share with us, into the QVD file attached.</P><P>Thanks again! <IMG alt="Yes" src="http://community.qlik.com/emoticons/emotion-21.gif" /></P></BODY></HTML> Thu, 22 Oct 2009 20:05:27 GMT https://community.qlik.com/t5/QlikView/12-month-accumulation-How-to/m-p/221814#M74585 2009-10-22T20:05:27Z 12-month accumulation / How to? https://community.qlik.com/t5/QlikView/12-month-accumulation-How-to/m-p/221815#M74586 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>see also this example (Set Analysis).</P><P>Good luck!</P><P>Rainer</P></BODY></HTML> Thu, 22 Oct 2009 20:52:28 GMT https://community.qlik.com/t5/QlikView/12-month-accumulation-How-to/m-p/221815#M74586 2009-10-22T20:52:28Z