Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
jaspreet_mehra2
New Contributor

Re: Not able to calculate Average distribution

Hello Rahul,

Thanks but to calculate "Average Cost Per Employee". i am using below mentioned logic

sum(aggr(SUM(DISTINCT Amount),Emp_id))/ COUNT(DISTINCT Emp_id)