topic Re: Reverse accumulation in QlikView

Reverse accumulation

agni_gold — Wed, 03 Feb 2016 14:56:31 GMT

Hi Experts,

I have made on bar chart , in which

Dimension : Day (1,2,3,4,5,6,7,... so on ) ------- Sorting order is ascending

Expression : sum(amount)

Full accumulation option is check in

Now i have changed the dimension sorting order to descending .

Now my chart is look like.

I just want , amount at day one should be at 9th day (like reverse).

Also attching the example file .

Please help.

Re: Reverse accumulation

sunny_talwar — Wed, 03 Feb 2016 15:07:18 GMT

Try this:

RangeSum(Below(sum(Amount), 0, Day))

Re: Reverse accumulation

agni_gold — Wed, 03 Feb 2016 15:13:34 GMT

I have tried your expression in my actual application , like below

=Rangesum(below(sum({<Date= {">=$(=min([Month Start Date]))<=$(=Date)"}> }[ERP Amount USD])/1000000,0,Day))

But it is showing amount at 9th day only

Re: Reverse accumulation

sunny_talwar — Wed, 03 Feb 2016 15:18:40 GMT

Try with RowNo() instead of Day

=RangeSum(Below(Sum({<Date= {">=$(=Min([Month Start Date]))<=$(=Date)"}> }[ERP Amount USD])/1000000,0,RowNo()))

Also make sure to add Date function around Min in your set analysis unless you date is a number.

Re: Reverse accumulation

swuehl — Wed, 03 Feb 2016 15:26:40 GMT

RowNo() will not accumulate to the bottom line:

=RangeSum(Below(Sum({<Date= {">=$(=Min([Month Start Date]))<=$(=Date)"}> }[ERP Amount USD])/1000000,0,NoOfRows()) )

=RangeSum(Below(Sum({<Date= {">=$(=Min([Month Start Date]))<=$(=Date)"}> }[ERP Amount USD])/1000000,0,(NoOfRows()-RowNo()+1)))

Re: Reverse accumulation

agni_gold — Wed, 03 Feb 2016 15:30:19 GMT

Thanks Sunny ,

I have tried in this way

=RangeSum(Below(Sum({<Date= {">=$(=Min([Month Start Date]))<=$(=Date)"}> }[ERP Amount USD])/1000000,0,)Sum({<Date= {">=$(=Min([Month Start Date]))<=$(=Date)"}> }Day))

It is also working ,

Am i doing correct ?