Calculating effort % from an Assignment Matrix

Fri, 02 Nov 2012 10:12:55 GMT

Back again to ask you a little help...

I have an Assignement Matrix or better a RAM (Responsibility Assignement Matrix) and i would like to calculate the effort for each office (in %).

Here is kind of example:

ACTIVITIES	OFFICE1	OFFICE2	OFFICE3
Activity 1	X		X
Activity 2		X
Activity 3		X	X
Activity 4			X

I would like to see a table like this one:

OFFICE	EFFORT
OFFICE1	25%
OFFICE2	50%
OFFICE3	75%

I first realised it in Excel using the COUNT.IF formula to count how many "X" are there for each office and then dividing by the # of total activities (in this case 4).

I actually can't find any count-if or similar in qlikview... could you help me?

Re: Calculating effort % from an Assignment Matrix

diegofcaivano — Fri, 02 Nov 2012 15:15:54 GMT

Hi. Please find attached an example that shows what you are looking for.

Regards.

topic Re: Calculating effort % from an Assignment Matrix in QlikView

Calculating effort % from an Assignment Matrix

Re: Calculating effort % from an Assignment Matrix