Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rohi__
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!

Labels (6)
1 Solution

Accepted Solutions
sunny_talwar

The dimension from your chart

View solution in original post

5 Replies
sunny_talwar

May be like this

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

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!

sunny_talwar

The dimension from your chart

rohi__
Contributor III
Contributor III
Author

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

sunny_talwar

Awesome!!