topic Full Accumulation in Straight Table, more than one Dimension in QlikView

Full Accumulation in Straight Table, more than one Dimension

Tue, 21 Feb 2012 18:34:41 GMT

Hi everybody, I´m Facing the problem to get Full Accumulation in a Straight Table with 3 Dimensions, I read in a few posts that the Full accumulation only works in a Straight Table with JUST one dimension, Does any body found a Solution for this BIG ISSUE????

Thank you Guys!!

Full Accumulation in Straight Table, more than one Dimension

swuehl — Tue, 21 Feb 2012 18:45:37 GMT

Try something like

=Rangesum(above(total Sum(Value),0,rowno(total)))

where sum(Value) is your expression you want to accumulate (i.e. replace the expression with the one you are using).

Full Accumulation in Straight Table, more than one Dimension

Tue, 21 Feb 2012 18:52:03 GMT

Thank you Stefan, This is the first time I see the solution for this problem, You are really Goog.

Thank you Again!!

Re: Full Accumulation in Straight Table, more than one Dimension

Tue, 21 Feb 2012 19:13:11 GMT

Stefan one last question, How could I get the "ABC VTA" Column according to my criterias??? I mean, How could I get the table on left side with 3 dimensions??

I attached the App, please be patient, I takes a few minutes.

I would be really thankfull on this problem.

Thank you again Stefan.

Re: Full Accumulation in Straight Table, more than one Dimension

swuehl — Tue, 21 Feb 2012 20:32:30 GMT

I added the expression, see attached.

Hope this helps (and in the future, please try to upload a little smaller examples, I think we will crash the Community server one day...),

Stefan

Re: Full Accumulation in Straight Table, more than one Dimension

brooksc57 — Mon, 27 Oct 2014 16:08:41 GMT

this worked for accumulation, but it freezes sorting...I'm looking but cannot yet determine why...any idea?