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
Creator III
Creator 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 resultStart resultDesired tableDesired table

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Try it with something like this:

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

- Marcus

View solution in original post

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Try it with something like this:

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

- Marcus

View solution in original post

Highlighted
Creator III
Creator III

Brilliant, Marcus!! Thank you very much!!