Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jerryr125
Creator III
Creator III

Avg Aggr issue

Hi - 

I am trying to create a KPI showing the average of the quantity sold / product name based upon the selection.

=Avg(aggr(sum(QuantitySold), [ProductName]))

Example - the three values are 483,404,1152.

The total is 2039 and average is 679.

It is displaying 2039 instead of 679 - thoughts ? 

1 Solution

Accepted Solutions
jerryr125
Creator III
Creator III
Author

Resolved...

=Avg(aggr(sum(QuantitySold), [SalesDate.autoCalendar.YearMonth]))

View solution in original post

1 Reply
jerryr125
Creator III
Creator III
Author

Resolved...

=Avg(aggr(sum(QuantitySold), [SalesDate.autoCalendar.YearMonth]))