topic Re: Average for (Week, Month and Year) in QlikView

Average for (Week, Month and Year)

tmumaw — Thu, 02 Mar 2017 19:57:35 GMT

Trying to figure out how to get some averages using the attached file. I need an average for the Profit Center by FISYR, FISPD and WEDAT. Would like to do this in the script if possible.

Thanks

Re: Average for (Week, Month and Year)

sunny_talwar — Thu, 02 Mar 2017 20:00:00 GMT

May be like this:

LOAD [Profit Center],

WEDAT,

FISYR,

FISPD,

Avg(NoEmp) as AvgNoEmp

Resident ....

Group By

[Profit Center],

WEDAT,

FISYR,

FISPD;

Re: Average for (Week, Month and Year)

tmumaw — Thu, 02 Mar 2017 20:18:18 GMT

Thanks Sunny......