topic something wrong in Average totals in QlikView

something wrong in Average totals

rmuhammad — Wed, 25 Nov 2020 16:16:04 GMT

Hi All

when I do totals for Avg it is not calculating correctly. Cant find logic how are these calculated. How can I fix this? please help. see attached sample app

Re: something wrong in Average totals

vishsaggi — Wed, 15 Nov 2017 20:20:15 GMT

Try this in your expr:

= AVG(Aggr(avg(HourlyRate), YEAR, DEPT, [EMP Start Dt]))

Re: something wrong in Average totals

sunny_talwar — Wed, 15 Nov 2017 20:26:01 GMT

Create your calculated dimension in the script and try this expression

Avg(Aggr(Avg(HourlyRate), YEAR, DEPT, [service yr]))

Re: something wrong in Average totals

rmuhammad — Wed, 15 Nov 2017 20:41:42 GMT

Thanks. it works