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

Announcements
Register by January 31 for $300 off your Qlik Connect pass: Register Now!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

aggr?

aggr(Avg(Total <Batch> Value), Batch)

how it caluclate?

1 Reply
Not applicable
Author

the aggr function makes a list.

So in your example you might have Batches: A, B, C, D, E....

Each of your Batches will have numerous values associated with them..

So your aggr function creates a list of average values based on Batch. For example:

avg(values associated with A)

avg(values associated with B)

avg(values associated with C)

avg(values associated with D)

avg(values associated with E)