Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
MVP & Luminary
MVP & Luminary

Try it with something like this:

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

- Marcus

View solution in original post

2 Replies
MVP & Luminary
MVP & Luminary

Try it with something like this:

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

- Marcus

View solution in original post

Creator III
Creator III

Brilliant, Marcus!! Thank you very much!!