topic Re: Accumulative sum per year in Line chart in App Development

Accumulative sum per year in Line chart

klbos — Wed, 22 Dec 2021 20:40:09 GMT

Dear community,

I have searched in I think almost every rangesum qeastion the past few days but I could not find a solution.

I want an accumulative sum per year in a line graph,with month as horizontal dimension. The expression I use now is :

RangeSum(Above(total Sum( Omzet), 0, RowNo(total)))

I want that every line starts at 0 and ends on the total revenue of that year.

Can anyone help me?

Below the data

Kind regards,

Klaas

Re: Accumulative sum per year in Line chart

Sue_Macaluso — Wed, 06 Mar 2019 13:28:51 GMT

Hi, Is this for QlikView or Sense? I would like to move it into the correct product forum for more attention. This forum is typically for general discussion.

Re: Accumulative sum per year in Line chart

klbos — Wed, 06 Mar 2019 13:30:50 GMT

Hi Sue,

This is for Sense.

Re: Accumulative sum per year in Line chart

dlm — Wed, 06 Mar 2019 13:46:37 GMT

Hi,

I think you have the expression slightly wrong.

Try and put it as follows in your line chart:

rangesum(above( sum(Revenue), 0, rowno() ))

I've created a small inline table with your 2016 data and it seems to add up correctly. Please note that I haven't attached it to a proper date field, so month 4 (which is not included into your data set for 2016) is not shown in the chart.

I hope this helps.

Best regars,

Re: Accumulative sum per year in Line chart

klbos — Wed, 06 Mar 2019 14:00:08 GMT

Hi,

Thank you for your response.

I already tried that expression but it is not working if I have year as second dimension (several years)

Regards,

Re: Accumulative sum per year in Line chart

dlm — Wed, 06 Mar 2019 14:14:25 GMT

Ah, yes you're right.

what about if you try the following:

(Aggr(RangeSum(Above(Sum(Revenue), 0, RowNo())), BookingYear, BookingMonth))

Seems to work in my example attached.

Best regards,

Re: Accumulative sum per year in Line chart

klbos — Wed, 06 Mar 2019 14:38:19 GMT

Dear DLM,

For some reason that works with the inline table but not with my whole dataset.

Re: Accumulative sum per year in Line chart

dlm — Wed, 06 Mar 2019 14:41:27 GMT

Are the fieldnames in the ‘inline table’ exactly the same as in your data model?

Re: Accumulative sum per year in Line chart

klbos — Fri, 08 Mar 2019 10:34:15 GMT

Jup! Are exactly the same.

I can solve it with several measures with Set analysis on the year field, but than it's not possible to select years.