Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
tmumaw
Valued Contributor

Average Calculations

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

Tags (1)
11 Replies

Re: Average Calculations

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

tmumaw
Valued Contributor

Re: Average Calculations

Yes average of EmpCt_ZEMPCT

tmumaw
Valued Contributor

Re: Average Calculations

Sunny do you have an example

Thanks

qlikview979
Valued Contributor

Re: Average Calculations

Not sure,


are you expecting like this


Untitled.png

tmumaw
Valued Contributor

Re: Average Calculations

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

qlikview979
Valued Contributor

Re: Average Calculations

Hi ,

PFA

tmumaw
Valued Contributor

Re: Average Calculations

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

tmumaw
Valued Contributor

Re: Average Calculations

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

qlikview979
Valued Contributor

Re: Average Calculations

Hi Are you  expecting like this

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