Discussion Board for collaboration related to QlikView App Development.
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?
Average of EmpCt_ZEMPCT? May be with cycle group and Profit Center as dimension and Avg(EmpCt_ZEMPCT) as expression?
Yes average of EmpCt_ZEMPCT
Sunny do you have an example
are you expecting like this
Yea something like that....can you attach the model please
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.
How can I get a sum of all the averages......
Hi Are you expecting like this