Summing totals by a dimension and then finding the average

[Mdjenkins]

Good morning guys.

How I can find the AVG of a Sum by a Dimension. 

To elaborate.  I have a table that has many rows for a vendor it may look something like this

VenderName   Count

VenderA             12

VenderB             11

VenderA             10

VenderA             10

VenderC             15

VenderC             20

For VenderA there total is 12+10+10 or 32

For VenderB there total is 11

For VendorC there total is 35

The value I am looking for is  26 (the average of 32,11 and 35)

How do I create an expression that will Sum the counts by Vendor and then give me the average of those sums

Thanks,

[sunny_talwar · Accepted solution]

May be this

Avg(Aggr(Sum(Count), VendorName))

[deborahs]

Mister Sunny, could you please explain the expression? I'm a student and new to Qlik and as per my understanding, count is a function and I'm not sure why have you used it in this. I'm just curious about the question.. Thanks in advance

[Mdjenkins]

Yes it looks like it worked. Thank you very much. It Aggragates the sum of count on vendorName and then finds and average.