topic Re: how to calculate average value? in QlikView

how to calculate average value?

francis_gr — Fri, 25 Jul 2014 11:19:46 GMT

Hi!

I have employee table with the sales per year (2011 to 2013)

I need that selecting a employee, calculate the average sales per year of all employees with the same job that the selected person .

I tried with Avg (Total ([ventas])) but doesn´t work (show the same wrong value each year)

Thanks

Re: how to calculate average value?

Greg_Williams — Fri, 25 Jul 2014 11:37:19 GMT

Have you tried avg(aggr(sum(sales),year))

Re: how to calculate average value?

swuehl — Fri, 25 Jul 2014 11:38:03 GMT

Maybe something like this:

avg({<JobField = p(), EmployeeField = >} [ventas])

in a chart with dimension Year and selecting in EmployeeField.

Re: how to calculate average value?

francis_gr — Fri, 25 Jul 2014 11:58:58 GMT

Thanks for your quick reply!!

I`ve tried your expresíon but it shows the same sales values that the person that i have selected, not the average values per year of all employees with the same job

Regards

Re: how to calculate average value?

francis_gr — Fri, 25 Jul 2014 12:19:55 GMT

Hi!

Thanks for your reply!

Show the same sales values per year that have the selected person, so i haven´t the average per year and job of the group to which the employee selected belongs

Regards