Qlik Community

Qlik Sense App Development

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

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

The dimension from your chart

View solution in original post

5 Replies
Highlighted

May be like this

Sum(Aggr(Avg(duration), Dimension/s))
Highlighted
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!

Highlighted

The dimension from your chart

View solution in original post

Highlighted
Contributor III
Contributor III

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

Highlighted

Awesome!!