Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Re: Accumulation in a Pivot table

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))))

1 Reply

Re: Accumulation in a Pivot table

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))))

Community Browser