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: 
bobbygino
Contributor
Contributor

Average age in a count expression

I want to calculate  an average age with a count distinct in an expression, need some help . thanks?

10 Replies
agigliotti
Partner - Champion
Partner - Champion

maybe this:

Avg( Aggr( Count(Distinct Age), your_dimension) )

bobbygino
Contributor
Contributor
Author

Is not working ,  I have a list of persons with different ages

ID  Age

A=45

B=35

C=25

D=56

now I want to calculate the average age of my list

=avg(aggr(ID),AGE)) ???

bobbygino
Contributor
Contributor
Author

=avg(aggr(count(ID),AGE)) ???

Mark_Little
Luminary
Luminary

Hi Marc,

I would Try something like the below

SUM(DISTINCT Age) / COUNT(DISTINCT Age)

Mark

agigliotti
Partner - Champion
Partner - Champion

maybe this:

Avg( Aggr( Count(Distinct AGE), ID) )

manoj217
Creator III
Creator III

this will shows the no of distinct values and finding the avg of that distinct values  not the ages

agigliotti
Partner - Champion
Partner - Champion

then simple use the below expression:

Sum(Age)

/

Count(ID)

prithviram777
Partner - Contributor III
Partner - Contributor III

Hi

try 

Avg(Aggr(sum( distinct (Age)),Age))

martinpohl
Partner - Master
Partner - Master

why do you want to use count in your expression?

avg (Agr) returns 40.24 (sum of 161 years devided by 4 ID)

Regards