Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculating Efficiency in Pivot Totals?

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

1 Solution

Accepted Solutions
jsn
Master
Master

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

2 Replies
jsn
Master
Master

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

Not applicable

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