Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Aggr function in Expressions

Hi,

Should somebody explained to me why the expression Aggr(Sum(WorkedHours), ProductionID) gives the same results for all the rows in a pivot table if I put it on the Dimensions section and it gives the result only for the first row if I put it on the expression section?

Thanks,

N.

1 Solution

Accepted Solutions
swuehl
MVP
MVP

It's probably due the chart dimension context. Have a look at the grain mismatch section in

Pitfalls of the Aggr function

View solution in original post

2 Replies
swuehl
MVP
MVP

It's probably due the chart dimension context. Have a look at the grain mismatch section in

Pitfalls of the Aggr function

Anonymous
Not applicable
Author

You're right.

Thank you so much.

N.