Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Why does average change when expanded in pivot table?

Good afternoon,

I have an expression like this using aggr in a pivot table : avg(aggr(sum(NETWIN),LLAVE)) , when it´s not expanded doesn´t make the average well but if I expand it and export the detail to excel I calculate the average and it is ok, do you know why does it happen?

Thanks

2 Replies
Not applicable
Author

Its depend on Your Dimension Values.

Not applicable
Author

Please post your Dimension you are using on the Pivot Table.