Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Pivot Table: Sum The Averages

Hello everyone,

can I display the Average Values in a Pivot-Table if it is expanded, but if it is collapsed it should not take the Average of all Values but the Sum of the Average...?

Right now i just used "Avg(duration)" on the measure field in the Pivot Table.

Thank you in advance!

1 Solution

Accepted Solutions

The dimension from your chart

View solution in original post

5 Replies

May be like this

Sum(Aggr(Avg(duration), Dimension/s))
Contributor III
Contributor III

Thank you for your fast reply @sunny_talwar !

If enter the Dimension that I am using, I am just getting "0"'s... 

Is there an explanation which Dimension / s I should use?

Thank you for your advice!

The dimension from your chart

View solution in original post

Contributor III
Contributor III

I used all the Dimensions from my Chart and it worked. Thanks @sunny_talwar