New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor

Show Average Productivity from Empoyees

Hi Qlik-Community,

i got stuck on a Problem several hours now and cant find a way to solve it. I got a table like this:

UserIdWorkingDurationWorkDateType AType B
107:00:002018-01-01990
208:12:002018-01-01054
17:49:002018-01-021190
306:31:002018-02-02061
45:41:002018-02-01570
39:01:012018-03-02074

Type A and Type B are two products some workers create Type A's and some create Type B's now i want to calculate the productivity of each Type. The Workers with UserId 1 and 4 work on Type A so the productivity is their Workduration/sum of TypeA.

The Workers with UserId 2 and 3 are working on Type B so their Productivity is their Workduration/sum of Type B.

Now i want to create a KPI for the Productivity of Type A and but when i do SUM(TypeA)/Sum(WorkDuration) i always get the Workingdurations from user 2 and 3 in it as well so it doesnt show the right productivity of the Type A. Any elegant solutions to fix it?

1 Solution

Accepted Solutions
MVP

Re: Show Average Productivity from Empoyees

May be this

Sum(TypeA)/Sum({<TypeA = {">0"}>}WorkDuration)