Accumulative sum per year in Line chart

[klbos]

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

[Sue_Macaluso]

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.

[klbos]

Hi Sue,

This is for Sense. 

[dlm]

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,

[klbos]

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, 

[dlm]

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,

[klbos]

Dear DLM,

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

[dlm]

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

[klbos]

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.