Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
BenGielen
Contributor III
Contributor III

accumulation of amount

Hi everybody,

i have a question about accumulate in a qlik sense table.

I have a table with 3 columns. See attached picture.
The first two columns should stay that way. Here you can see the sum of sales per item. Sorted by total sales.

I don't get the third column as shown in the picture. Here I would like to show the sum sales in a commulated manner.

Can someone help me with this?

Thank you very much.

Ben

1 Solution

Accepted Solutions
micheledenardi
Specialist II
Specialist II

Try to put this expression in your table: 

rangesum(above(total sum(Amount), 0, rowno(Total)))

Or you can set Accumulation modifier under your measure expression option:

2021-02-11 10_40_47-Window.png

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

2 Replies
micheledenardi
Specialist II
Specialist II

Try to put this expression in your table: 

rangesum(above(total sum(Amount), 0, rowno(Total)))

Or you can set Accumulation modifier under your measure expression option:

2021-02-11 10_40_47-Window.png

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
BenGielen
Contributor III
Contributor III
Author

Thank you for your answer. 

i saw that this works only for two dimensions.