Qlik Community

Qlik Sense App Development

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

Highlighted
rohi__
New Contributor II

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

Re: Pivot Table: Sum The Averages

The dimension from your chart

5 Replies

Re: Pivot Table: Sum The Averages

May be like this

Sum(Aggr(Avg(duration), Dimension/s))
rohi__
New Contributor II

Re: Pivot Table: Sum The Averages

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!

Re: Pivot Table: Sum The Averages

The dimension from your chart

rohi__
New Contributor II

Re: Pivot Table: Sum The Averages

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

Re: Pivot Table: Sum The Averages

Awesome!!