Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Calculating effort % from an Assignment Matrix

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:

ACTIVITIESOFFICE1OFFICE2OFFICE3
Activity 1XX
Activity 2X
Activity 3XX
Activity 4X

I would like to see a table like this one:

OFFICEEFFORT
OFFICE125%
OFFICE250%
OFFICE375%

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?

1 Reply
diegofcaivano
Contributor

Re: Calculating effort % from an Assignment Matrix

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

Regards.

Community Browser