Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Accumulation in a Pivot table

Hey,

I want to build an expression where I can see the accumulated sum of one field. I started with an RangeSum function and everthing looks fine but on the second view I saw that when I click on a date the accumulation will start from the beginning. Is there a possibility to create a function which gives back the "total" accumulation when I click on a specific date.

Please look at my example...

Thank you!

PS. My goal is to build a function in the frontend and not in the script enviroment.

1 Solution

Accepted Solutions
sunny_talwar

I cannot see your qvw (as I am working with Personal Edition), but try something like this:

If(Sum(Sales) > 0, RangeSum(Above(TOTAL Sum({<DateField = >}Sales), 0, RowNo(TOTAL))))

View solution in original post

1 Reply
sunny_talwar

I cannot see your qvw (as I am working with Personal Edition), but try something like this:

If(Sum(Sales) > 0, RangeSum(Above(TOTAL Sum({<DateField = >}Sales), 0, RowNo(TOTAL))))