topic Proportion per group in QlikView

Proportion per group

Stravan — Sun, 20 Oct 2019 22:32:38 GMT

Hi,

I need to calculate the percentage (percent) within each group A and B, not per Test (which is a cyclic group) but per group, see the picture. How can I calculate % A and % B?

Thank you in advance

Test	#A	%A	#B	%B
Test1	110	18%	55	26%
Test2	200	33%	120	57%
Test3	300	49%	35	17%
Total	610	100%	210	100%

Re: Proportion per group

Lisa_P — Sun, 20 Oct 2019 23:04:08 GMT

See screenshot:

Re: Proportion per group

Stravan — Mon, 21 Oct 2019 08:56:56 GMT

Thank you for your replay.

Do I have to count for each column manually? Is there any way to do it right away? The problem is that #A and #B are not their own variables / fields, they are the value of a field called "Type".

Here is my table from QlikView, as you can see the percentage is by sex, I want to have a Type?

I don't want the sum of% A-E = 100%, I want% Female +% Male = 100%

Type	#A	%A	#B	%B	#C	%C	#D	%D	#E	%E
Sex	num(sum(Salary), '###0')	num(sum(Salary), '###0')/num(sum(TOTAL Salary), '###0')	num(sum(Salary), '###0')	num(sum(Salary), '###0')/num(sum(TOTAL Salary), '###0')	num(sum(Salary), '###0')	num(sum(Salary), '###0')/num(sum(TOTAL Salary), '###0')	num(sum(Salary), '###0')	num(sum(Salary), '###0')/num(sum(TOTAL Salary), '###0')	num(sum(Salary), '###0')	num(sum(Salary), '###0')/num(sum(TOTAL Salary), '###0')
Female	88146	22%	4639	1%	46978	12%	55673	14%	17273	4%
Male	39750	10%	3583	1%	56526	14%	58625	14%	33213	8%
Total	127896	32%	8222	2%	103504	26%	114298	28%	50487	12%

Re: Proportion per group

Stravan — Mon, 21 Oct 2019 14:58:51 GMT

Now the problem has been solved by the formula below:

num(sum(Salary), '###0')/num(sum(TOTAL <Type> Salary), '###0')