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

How to accumulate in a Pivot table?

I want to show the accumulate by month per year in a pivot table. Is it possible? How would I accomplish this? I attached a photo of what my pivot table looks like. Basically a accumulation month over month.

5 Replies
Highlighted

So you want to accumulate across your months and not go down? Use ColumnNo() instead of RowNo() and Before/Atfer instead of Above/Below in your RangeSum() function

Highlighted
Creator III
Creator III

Hi -

You can use

For Counts

Rangesum(before(Count[Field]),0,12))

For Sum

Rangesum(before(Sum[Field]),0,12))


where - 0 is an offset and 12 is the "Counter" - assuming you want to accumulate it for 12 months. You may adjust it based on your need.



FYI


https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/Inte...

Highlighted
Partner
Partner

Yes I want it to accumulate across. So would I have 2 expressions? Currently I have SUM(Net Sales Amount).

Highlighted
Creator III
Creator III

Ok  then use

Rangesum(before(Sum[Net Sales Amount]),0,12))


I have just given examples of Sum and Count. You can use as per your need.

Highlighted

You can do what jayanttibhe‌ mentioned, or use this

RangeSum(Before(Sum([Net Sales Amount]), 0, ColumnNo()))