Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Highlighted
hansdevr
Contributor II

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

Re: Show Average in Horizontal Pivot Table

Try it with something like this:

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

- Marcus

2 Replies

Re: Show Average in Horizontal Pivot Table

Try it with something like this:

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

- Marcus

hansdevr
Contributor II

Re: Show Average in Horizontal Pivot Table

Brilliant, Marcus!! Thank you very much!!

Community Browser