Your request can go towards 2 directions:
- bucketing on some already calculated values, that are available in a field of a table.
- bucketing for some aggregated values, that are not already precal !culated in
The first one should be straight forward, using class function, for regular intervals (or you can check an exponential interval bucketing solution explained in our blog here: Creating exponential buckets in QlikView charts | QQinfo | Informatie inteligenta cu viteza gandului )
The second request can get a little bit tricky..., but here it is attached a small prototype I made today that I believe it could cover your need... I assumed you have one table with all transactions, like a Transaction Journal, and that you have already matched in the script the payments to certain invoices. (If you have not this, you can call us to help you on that, too )