Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
mato32188
Creator III
Creator 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

ECG line chart is the most important visualization in your life.
7 Replies
sunny_talwar

Try this

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

sunny_talwar

Or this

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

mato32188
Creator III
Creator III
Author

Hi,

thank you.

Unfortunately, no one works.

ECG line chart is the most important visualization in your life.
sunny_talwar

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

mato32188
Creator III
Creator III
Author

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

ECG line chart is the most important visualization in your life.
sunny_talwar

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

petter
MVP
MVP

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 )