Solved: Calculating Efficiency in Pivot Totals? - Qlik Community

Report Inappropriate Content · ‎2010-01-10

Hi,

Trying to calculate the efficiency of employees based on their individual actual production and time and the target for 7 hours. I have not problem to get this for each employeeagainst their individual actvity. But for obvious reasons, the employee efficiency for all the activities is an incorrect answer. Can someone help please. Sample attached.

Nimish

Anonymous · ‎2010-01-10

Hi Nimish,

If I understand the issue correctly then your problem is the totals.

Try changing the expression (nr 3 - Equated for 7 hours) to: sum(aggr((Sum(Volume)/(Sum(TimeTaken)*24)*7), Name, ActivityName))

Also change the last expression to: sum(aggr((Sum(Volume)/(Sum(TimeTaken)*24)*7), Name, ActivityName))/(Sum(TargetVol))

View solution in original post

Anonymous · ‎2010-01-10

Hi Nimish,

If I understand the issue correctly then your problem is the totals.

Try changing the expression (nr 3 - Equated for 7 hours) to: sum(aggr((Sum(Volume)/(Sum(TimeTaken)*24)*7), Name, ActivityName))

Also change the last expression to: sum(aggr((Sum(Volume)/(Sum(TimeTaken)*24)*7), Name, ActivityName))/(Sum(TargetVol))

Report Inappropriate Content · ‎2010-01-11

Hi Johannes,

Thank you for the quick solution. I am travelling just now but will use this in the production tables (there are lot of set modfiers also) and check this. I think this should work but will confirm and verify the answer once I have tried it on the actual tables.

Nimish