Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

hansdevr
Contributor III

Show Average in Horizontal Pivot Table

Good morning specialists!

I need to do a horizontal (left to right) accumulation in a triangular pivot table.

Showing you starting table and desired result. Anyone suggestions how to go about this problem?

Start table.PNGStart resultResult table.PNGDesired table

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Show Average in Horizontal Pivot Table

Try it with something like this:

rangesum(before(sum(YourValue), 0, columnno()))

- Marcus

2 Replies
MVP & Luminary
MVP & Luminary

Re: Show Average in Horizontal Pivot Table

Try it with something like this:

rangesum(before(sum(YourValue), 0, columnno()))

- Marcus

hansdevr
Contributor III

Re: Show Average in Horizontal Pivot Table

Brilliant, Marcus!! Thank you very much!!