Discussion Board for collaboration related to Creating Analytics for QlikView.
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:
I would like to see a table like this one:
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?
Hi. Please find attached an example that shows what you are looking for.