topic Calculating Efficiency in Pivot Totals? in QlikView

Calculating Efficiency in Pivot Totals?

Mon, 11 Jan 2010 00:25:12 GMT

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

Calculating Efficiency in Pivot Totals?

Anonymous — Mon, 11 Jan 2010 03:07:57 GMT

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))

Calculating Efficiency in Pivot Totals?

Tue, 12 Jan 2010 01:38:23 GMT

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