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
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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

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

View solution in original post

BenGielen
Contributor III
Contributor III
Author

Thank you for your answer. 

i saw that this works only for two dimensions.