Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
krishna4bo
Contributor

Calculate AVG Head count

   Hi All,

How to calculate AVG Head count for all Quarters.

Actual Head count:

 

Q1 7256

 

Q2 7553

 

Q3 7599

 

Q4 7699

 

Average head count:

 

Q1 6807

  EX: Q1=Apr,May,Jun

 

6681 +6759+6981=20421/3= 6807

 

1 Solution

Accepted Solutions

Re: Calculate AVG Head count

Try this expression:

=Avg(Aggr(Count(DISTINCT([Emp. Id])), Month))


Capture.PNG

4 Replies

Re: Calculate AVG Head count

Can you reload the application and reattach? The attached application doesn't seem to have Emp ID field in it

krishna4bo
Contributor

Re: Calculate AVG Head count

Hi Sunny ,

I reattached.

Thanks,

Krishna

Re: Calculate AVG Head count

Try this expression:

=Avg(Aggr(Count(DISTINCT([Emp. Id])), Month))


Capture.PNG

Chanty4u
Esteemed Contributor III

Re: Calculate AVG Head count