
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Table with cumul and rate
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% |
- Tags:
- rating
- static table
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
PFA

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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))

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Great! I used Full Accumulation case but the problem was in the rate

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Awesome , So everything working perfectly now?
Best,
Sunny

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yes!
