Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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
Highlighted

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