Table with cumul and rate

[#1]

Hello,

I'm triying to do this table with QV and I can't realise it like that:

(See attached file)

-	En banque	impayé	Cumul  En banque	cumul impayé	taux
janvier	1000	200	1000	200	20%
février	2000	100	3000	300	10%
mars	5000	50	8000	350	4%
avril	3000	0	11000	350	3%
mai	2000	200	13000	550	4%
juin	5000	100	18000	650	4%
juillet	1000	600	19000	1250	7%
août	2000	400	21000	1650	8%
septembre	5000	300	26000	1950	8%
octobre	500	0	26500	1950	7%
novembre	8000	6000	34500	7950	23%
décembre	11000	4000	45500	11950	26%

[sunny_talwar · Accepted solution]

PFA

[#3]

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]), 0, 9999))

[sunny_talwar]

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)

This is QlikView inbuilt accumulation function available only for straight tables.

HTH

[#5]

Great! I used Full Accumulation case but the problem was in the rate

[sunny_talwar]

Awesome , So everything working perfectly now?

Best,

Sunny

[#7]

Yes!