Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mato32188
Contributor III

Accumulation - outer/inner dimension

Hello guys,

very quick question. I would like to accumulate over inner dimension (Dim2). Without editing script.

Current:

Img.PNG

Desired:

accumulated sum(Exp) in Pivot table

24.1.2018 P0 23.25

                 P1 12.25

                 P2 10.20

"TOTAL"        45.70

...

29.1.2018 P0 23.25

                 P1 12.25

                 P2 11.20

"TOTAL"        46.70

...

30.1.2018 P0 23.25

                 P1 13.25

                 P2 11.20

"TOTAL"        47.70

...

Thank you.

BR

Martin

Tags (1)
7 Replies
MVP
MVP

Re: Accumulation - outer/inner dimension

Try this

Aggr(RangeSum(Above(Sum(Exp), 0, RowNo())), Dim2, Dim1)

MVP
MVP

Re: Accumulation - outer/inner dimension

Or this

Aggr(RangeSum(Above(Sum(Exp), 0, RowNo())), Dim2, (Dim1, (NUMERIC)))

mato32188
Contributor III

Re: Accumulation - outer/inner dimension

Hi,

thank you.

Unfortunately, no one works.

MVP
MVP

Re: Accumulation - outer/inner dimension

Would you be able to share a sample to show what you have?

mato32188
Contributor III

Re: Accumulation - outer/inner dimension

Sorry, I can't. Anyway thanks for your hints.

MVP
MVP

Re: Accumulation - outer/inner dimension

All we wanted to was to do this in a dummy data... you sample image attached looks like a dummy data with Dim1, Dim2 can't be your real dimensions? You can't share dummy data?

Anyways, I still believe that the expression should work... what do you see when you use the provided expression?

In case, the issue has been resolved, I would suggest closing it down by marking correct and helpful responses.

Best,

Sunny

MVP
MVP

Re: Accumulation - outer/inner dimension

If all you want to do is limit the Dim2 to the three values P0,P1,P2 then this measure expression should work for you:

Sum( {<Dim2={'P0','P1','P2'}>} Exp )