topic Re: Average Calculations in QlikView

Average Calculations

tmumaw — Fri, 12 May 2017 15:39:22 GMT

Hi all,

I need to be able to calculate averages at different levels using one QVD. I need averages for WKNO, FISPD, QTR and FISYR for each profit center. Any ideas?

Thanks

Re: Average Calculations

sunny_talwar — Fri, 12 May 2017 15:45:02 GMT

Average of EmpCt_ZEMPCT? May be with cycle group and Profit Center as dimension and Avg(EmpCt_ZEMPCT) as expression?

Re: Average Calculations

tmumaw — Fri, 12 May 2017 15:50:02 GMT

Yes average of EmpCt_ZEMPCT

Re: Average Calculations

tmumaw — Mon, 15 May 2017 11:54:54 GMT

Sunny do you have an example

Thanks

Re: Average Calculations

qlikview979 — Mon, 15 May 2017 12:04:26 GMT

Not sure,

are you expecting like this

Re: Average Calculations

tmumaw — Mon, 15 May 2017 12:06:59 GMT

Yea something like that....can you attach the model please

Re: Average Calculations

qlikview979 — Mon, 15 May 2017 12:08:56 GMT

Hi ,

PFA

Re: Average Calculations

tmumaw — Mon, 15 May 2017 12:19:51 GMT

Mahesh,

I think you misunderstood me. I need to know the average number of employees by FISYR, QTR, FISPD and WKNO, Not the averages of the time dims.

Thanks

Re: Average Calculations

tmumaw — Mon, 15 May 2017 18:15:20 GMT

How can I get a sum of all the averages......

Re: Average Calculations

qlikview979 — Tue, 16 May 2017 05:43:07 GMT

Hi Are you expecting like this

avg(WKNO+FISPD+FISYR+QTR+EmpCt_ZEMPCT)

Re: Average Calculations

qlikview979 — Tue, 16 May 2017 06:29:21 GMT

Hi ,

can you please share the expected output.

regards

Re: Average Calculations

tmumaw — Tue, 16 May 2017 12:32:59 GMT

Here is what I have:

I use sum(aggr(avg(EmpCt_ZEMPCT),[PC Desc],FISYR)) to get the Avg Employee counts by year.

I use sum(aggr(avg(EmpCt_ZEMPCT),[PC Desc],FISYR,Action)) to get the Avg Employee counts by year. and action. I'm sort of confused on what this is giving me.

Thanks