topic Re: Rangesum/accumulation issue in QlikView

Rangesum/accumulation issue

mike_spada — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have this issue: I have a line chart with two dimensions - year and month - and an expression (count(night)) because in my data in night column I have a 'x' to mark if a person works by night.

In my original chart I used "Full accumulation" to see the progression of the nights, and I'm happy.

Tring to port my chat in Sense I see that there is not a "Full accumulation", so I read in community that - even in QlikView, not only in Sense - the situation can be solved using rangesum function. But I can't make it work! 😞

Anyone can tell me where am I doing wrong?

I attached a sample.

Thanks!

Mike

Re: Rangesum/accumulation issue

sunny_talwar — Fri, 27 May 2016 15:37:44 GMT

Try this:

Aggr(RangeSum(Above(count(Notte),0,RowNo())), (Anno, (NUMERIC)), ([Mese breve], (NUMERIC)))

This will work in Qlik Sense and QlikView 12 and above

The sortable Aggr function is finally here!

Re: Rangesum/accumulation issue

mike_spada — Mon, 30 May 2016 07:12:31 GMT

It works!

Thank you,

S. Mike

Re: Rangesum/accumulation issue

agigliotti — Mon, 21 Nov 2016 09:49:53 GMT

I need to have the column total with rangesum being calculated, not 0 like above.

Is it possible ?

Re: Rangesum/accumulation issue

Anil_Babu_Samineni — Mon, 21 Nov 2016 12:13:49 GMT

Sunny, What was the intend in you expression for this, NUMERIC to add. Please describe if you are free

Aggr(RangeSum(Above(count(Notte),0,RowNo())), Anno, [Mese breve])