topic Re: Table with cumul and rate in QlikView https://community.qlik.com/t5/QlikView/Table-with-cumul-and-rate/m-p/886620#M309097 <HTML><HEAD></HEAD><BODY><P>I just added a large number here which is basically saying that you want to do a accumulation for last 9999 rows. If you believe that your table will have more than 9999 rows, you can increase that number to 9999999 (or something that would continue to accumulate for you). There is another way you can do this (PFA)</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/86888_Capture.PNG" style="height: 389px; width: 620px;" /></P><P></P><P>This is QlikView inbuilt accumulation function available only for straight tables.</P><P></P><P>HTH</P></BODY></HTML> Tue, 19 May 2015 11:05:10 GMT sunny_talwar 2015-05-19T11:05:10Z Table with cumul and rate https://community.qlik.com/t5/QlikView/Table-with-cumul-and-rate/m-p/886617#M309094 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I'm triying to do this table with QV and I can't realise it like that:</P><P>(See attached file)</P><P></P><P></P><TABLE><TBODY><TR><TD>-</TD><TD>En banque</TD><TD>impayé</TD><TD>Cumul&nbsp; En banque</TD><TD>cumul impayé</TD><TD>taux</TD></TR><TR><TD>janvier</TD><TD>1000</TD><TD>200</TD><TD>1000</TD><TD>200</TD><TD>20%</TD></TR><TR><TD>février</TD><TD>2000</TD><TD>100</TD><TD>3000</TD><TD>300</TD><TD>10%</TD></TR><TR><TD>mars</TD><TD>5000</TD><TD>50</TD><TD>8000</TD><TD>350</TD><TD>4%</TD></TR><TR><TD>avril</TD><TD>3000</TD><TD>0</TD><TD>11000</TD><TD>350</TD><TD>3%</TD></TR><TR><TD>mai</TD><TD>2000</TD><TD>200</TD><TD>13000</TD><TD>550</TD><TD>4%</TD></TR><TR><TD>juin</TD><TD>5000</TD><TD>100</TD><TD>18000</TD><TD>650</TD><TD>4%</TD></TR><TR><TD>juillet</TD><TD>1000</TD><TD>600</TD><TD>19000</TD><TD>1250</TD><TD>7%</TD></TR><TR><TD>août</TD><TD>2000</TD><TD>400</TD><TD>21000</TD><TD>1650</TD><TD>8%</TD></TR><TR><TD>septembre</TD><TD>5000</TD><TD>300</TD><TD>26000</TD><TD>1950</TD><TD>8%</TD></TR><TR><TD>octobre</TD><TD>500</TD><TD>0</TD><TD>26500</TD><TD>1950</TD><TD>7%</TD></TR><TR><TD>novembre</TD><TD>8000</TD><TD>6000</TD><TD>34500</TD><TD>7950</TD><TD>23%</TD></TR><TR><TD>décembre</TD><TD>11000</TD><TD>4000</TD><TD>45500</TD><TD>11950</TD><TD>26%</TD></TR></TBODY></TABLE></BODY></HTML> Tue, 19 May 2015 10:31:14 GMT https://community.qlik.com/t5/QlikView/Table-with-cumul-and-rate/m-p/886617#M309094 2015-05-19T10:31:14Z Re: Table with cumul and rate https://community.qlik.com/t5/QlikView/Table-with-cumul-and-rate/m-p/886618#M309095 <HTML><HEAD></HEAD><BODY><P>PFA</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/86886_Capture.PNG" style="height: 260px; width: 620px;" /></P></BODY></HTML> Tue, 19 May 2015 10:54:03 GMT https://community.qlik.com/t5/QlikView/Table-with-cumul-and-rate/m-p/886618#M309095 sunny_talwar 2015-05-19T10:54:03Z Re: Table with cumul and rate https://community.qlik.com/t5/QlikView/Table-with-cumul-and-rate/m-p/886619#M309096 <HTML><HEAD></HEAD><BODY><P>Thanks a lot for your reply and time, I've tried this expression but the problem that I can't inderstand the last part of this expression in Bold (=RangeSum(Above(Sum([En banque]), <STRONG>0, 9999</STRONG>))</P></BODY></HTML> Tue, 19 May 2015 11:00:14 GMT https://community.qlik.com/t5/QlikView/Table-with-cumul-and-rate/m-p/886619#M309096 2015-05-19T11:00:14Z Re: Table with cumul and rate https://community.qlik.com/t5/QlikView/Table-with-cumul-and-rate/m-p/886620#M309097 <HTML><HEAD></HEAD><BODY><P>I just added a large number here which is basically saying that you want to do a accumulation for last 9999 rows. If you believe that your table will have more than 9999 rows, you can increase that number to 9999999 (or something that would continue to accumulate for you). There is another way you can do this (PFA)</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/86888_Capture.PNG" style="height: 389px; width: 620px;" /></P><P></P><P>This is QlikView inbuilt accumulation function available only for straight tables.</P><P></P><P>HTH</P></BODY></HTML> Tue, 19 May 2015 11:05:10 GMT https://community.qlik.com/t5/QlikView/Table-with-cumul-and-rate/m-p/886620#M309097 sunny_talwar 2015-05-19T11:05:10Z Re: Table with cumul and rate https://community.qlik.com/t5/QlikView/Table-with-cumul-and-rate/m-p/886621#M309098 <HTML><HEAD></HEAD><BODY><P>Great! I used Full Accumulation case but the problem was in the rate</P></BODY></HTML> Tue, 19 May 2015 11:12:11 GMT https://community.qlik.com/t5/QlikView/Table-with-cumul-and-rate/m-p/886621#M309098 2015-05-19T11:12:11Z Re: Table with cumul and rate https://community.qlik.com/t5/QlikView/Table-with-cumul-and-rate/m-p/886622#M309099 <HTML><HEAD></HEAD><BODY><P>Awesome <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />, So everything working perfectly now?</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Tue, 19 May 2015 11:13:15 GMT https://community.qlik.com/t5/QlikView/Table-with-cumul-and-rate/m-p/886622#M309099 sunny_talwar 2015-05-19T11:13:15Z Re: Table with cumul and rate https://community.qlik.com/t5/QlikView/Table-with-cumul-and-rate/m-p/886623#M309100 <HTML><HEAD></HEAD><BODY><P>Yes!</P></BODY></HTML> Tue, 19 May 2015 11:34:47 GMT https://community.qlik.com/t5/QlikView/Table-with-cumul-and-rate/m-p/886623#M309100 2015-05-19T11:34:47Z