Discussion Board for collaboration related to QlikView App Development.
How to calculate AVG Head count for all Quarters.
Actual Head count:
Average head count:
6681 +6759+6981=20421/3= 6807
Go to Solution.
Try this expression:
=Avg(Aggr(Count(DISTINCT([Emp. Id])), Month))
Can you reload the application and reattach? The attached application doesn't seem to have Emp ID field in it
Hi Sunny ,
Average – Which average?