topic Re: 2 Month rolling figures in QlikView

topic Re: 2 Month rolling figures in QlikView https://community.qlik.com/t5/QlikView/2-Month-rolling-figures/m-p/426802#M159009 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please go through the post:  <A _jive_internal="true" class="loading active_link" href="https://community.qlik.com/thread/38355">http://community.qlik.com/thread/38355</A></P><P></P><P></P><P>HTH</P><P>Sushil</P></BODY></HTML> Fri, 05 Apr 2013 16:24:34 GMT sushil353 2013-04-05T16:24:34Z 2 Month rolling figures https://community.qlik.com/t5/QlikView/2-Month-rolling-figures/m-p/426801#M159008 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am looking for a way so that for each transaction month, it should also include the previous 2 months as well, so it is a rolling figure.</P><P></P><P>e.g.</P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Month</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Value</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>2 Month Value</STRONG></SPAN></TH></TR><TR><TD>Jan2013</TD><TD>100</TD><TD><STRONG>800</STRONG> (Jan2013+Dec2012+Nov2012)</TD></TR><TR><TD>Dec2012</TD><TD>200</TD><TD><STRONG>750</STRONG> (Dec2012+Nov2012+October2012)</TD></TR><TR><TD>Nov2012</TD><TD>500</TD><TD>(Nov2012+Oct2012+Sept2012)</TD></TR><TR><TD>Oct2012</TD><TD>50</TD><TD>(Oct2012+Sept2012+Aug2012)</TD></TR></TBODY></TABLE><P></P><P>I would also like to do this for weeks as well.</P><P></P><P>Thanks in advance </P></BODY></HTML> Fri, 05 Apr 2013 15:56:38 GMT https://community.qlik.com/t5/QlikView/2-Month-rolling-figures/m-p/426801#M159008 2013-04-05T15:56:38Z Re: 2 Month rolling figures https://community.qlik.com/t5/QlikView/2-Month-rolling-figures/m-p/426802#M159009 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please go through the post:  <A _jive_internal="true" class="loading active_link" href="https://community.qlik.com/thread/38355">http://community.qlik.com/thread/38355</A></P><P></P><P></P><P>HTH</P><P>Sushil</P></BODY></HTML> Fri, 05 Apr 2013 16:24:34 GMT https://community.qlik.com/t5/QlikView/2-Month-rolling-figures/m-p/426802#M159009 sushil353 2013-04-05T16:24:34Z