topic Last 3 months accumulate values in QlikView https://community.qlik.com/t5/QlikView/Last-3-months-accumulate-values/m-p/373415#M138931 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P></P><P>I need your help. I need to calculate values based on the last 3 months. My dataset doesn't contain values for all months. Please take a look into table below.</P><P>Problem in Accum by last 3 month. I'm not sure if I can use Rank function for it.</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="229" style="width: 579px; border: 1px solid rgb(0, 0, 0); height: 206px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Year_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>Accum</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Accum by last 3 month</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"> <STRONG style="color: #ffffff; text-align: -webkit-center; background-color: #6690bc;">Accum by last 3 month (Formula)</STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR /></TH></TR><TR><TD>2012.01</TD><TD>100</TD><TD>100</TD><TD>100</TD><TD>2012.01</TD></TR><TR><TD>2012.02</TD><TD>150</TD><TD>250</TD><TD>250</TD><TD>2012.02 + 2012.01</TD></TR><TR><TD>2012.03</TD><TD>50</TD><TD>300</TD><TD>300</TD><TD>2012.03 + 2012.02 + 2012.01</TD></TR><TR><TD>2012.06</TD><TD>300</TD><TD>600</TD><TD>300</TD><TD>2012.06 +<SPAN style="color: #ff0000;"> 2012.05 + 2012.04</SPAN></TD></TR><TR><TD>2012.08</TD><TD>200</TD><TD>800</TD><TD>500</TD><TD>2012.08 +<SPAN style="color: #ff0000;"> 2012.07</SPAN> + 2012.06</TD></TR><TR><TD>2012.09</TD><TD>150</TD><TD>950</TD><TD>350</TD><TD>2012.09 + 2012.08 + <SPAN style="color: #ff0000;">2012.07</SPAN></TD></TR><TR><TD>2012.10</TD><TD>50</TD><TD>1000</TD><TD>400</TD><TD>2012.10 + 2012.09 + 2012.08</TD></TR><TR><TD>2012.12</TD><TD>300</TD><TD>1300</TD><TD>350</TD><TD>2012.12 + <SPAN style="color: #ff0000;">2012.11</SPAN> + 2012.10</TD></TR></TBODY></TABLE><P></P><P>Thanks in advance for your help!</P></BODY></HTML> Mon, 30 Jul 2012 07:42:38 GMT 2012-07-30T07:42:38Z Last 3 months accumulate values https://community.qlik.com/t5/QlikView/Last-3-months-accumulate-values/m-p/373415#M138931 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P></P><P>I need your help. I need to calculate values based on the last 3 months. My dataset doesn't contain values for all months. Please take a look into table below.</P><P>Problem in Accum by last 3 month. I'm not sure if I can use Rank function for it.</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="229" style="width: 579px; border: 1px solid rgb(0, 0, 0); height: 206px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Year_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>Accum</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Accum by last 3 month</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"> <STRONG style="color: #ffffff; text-align: -webkit-center; background-color: #6690bc;">Accum by last 3 month (Formula)</STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR /></TH></TR><TR><TD>2012.01</TD><TD>100</TD><TD>100</TD><TD>100</TD><TD>2012.01</TD></TR><TR><TD>2012.02</TD><TD>150</TD><TD>250</TD><TD>250</TD><TD>2012.02 + 2012.01</TD></TR><TR><TD>2012.03</TD><TD>50</TD><TD>300</TD><TD>300</TD><TD>2012.03 + 2012.02 + 2012.01</TD></TR><TR><TD>2012.06</TD><TD>300</TD><TD>600</TD><TD>300</TD><TD>2012.06 +<SPAN style="color: #ff0000;"> 2012.05 + 2012.04</SPAN></TD></TR><TR><TD>2012.08</TD><TD>200</TD><TD>800</TD><TD>500</TD><TD>2012.08 +<SPAN style="color: #ff0000;"> 2012.07</SPAN> + 2012.06</TD></TR><TR><TD>2012.09</TD><TD>150</TD><TD>950</TD><TD>350</TD><TD>2012.09 + 2012.08 + <SPAN style="color: #ff0000;">2012.07</SPAN></TD></TR><TR><TD>2012.10</TD><TD>50</TD><TD>1000</TD><TD>400</TD><TD>2012.10 + 2012.09 + 2012.08</TD></TR><TR><TD>2012.12</TD><TD>300</TD><TD>1300</TD><TD>350</TD><TD>2012.12 + <SPAN style="color: #ff0000;">2012.11</SPAN> + 2012.10</TD></TR></TBODY></TABLE><P></P><P>Thanks in advance for your help!</P></BODY></HTML> Mon, 30 Jul 2012 07:42:38 GMT https://community.qlik.com/t5/QlikView/Last-3-months-accumulate-values/m-p/373415#M138931 2012-07-30T07:42:38Z Re: Last 3 months accumulate values https://community.qlik.com/t5/QlikView/Last-3-months-accumulate-values/m-p/373416#M138932 <HTML><HEAD></HEAD><BODY><P>you can use Above function to achieve that.</P></BODY></HTML> Mon, 30 Jul 2012 07:52:05 GMT https://community.qlik.com/t5/QlikView/Last-3-months-accumulate-values/m-p/373416#M138932 giakoum 2012-07-30T07:52:05Z