% AGAINST TOTAL

[upaliwije]

Hi Friends

In my QV document I have following pivot table

1	2	3
CLASS	NOS	%
A	1,461	95%
A	73	5%
A	1	0%
A	1,535	100%
B	187	96%
B	8	4%
B	195	100%
B	1,175	94%
B	77	6%
B	0	0%
B	1	0%
B	1,253	100%
C.	21,727	93%
C.	1,646	7%
C.	11	0%
C.	1	0%
C.	1	0%
C.	23,386	100%
D	856	84%
D	154	15%
D	5	0%
D	1	0%
D	1,016	100%
TOTAL	27,385	100%

In fact data is available only for Column 1 and 2 . I want to calculate % as shown in cloumn 3. Pls help me to write a expression for it

[sunny_talwar]

How are you calculating those percentages out of QlikView? Can you explain the logic?

[upaliwije]

That is why I m seeking your help to know whether there is any possibility of doing so in QV

[sunny_talwar]

We can do things which have some logic. Unless you know what the logic is, I feel I won't be much of a help because I def. do not know what logic is being followed .

[upaliwije]

Thanks

In Fact my logic is to calculate the % of Nos within each class

[settu_periasamy]

Try Like this..

=sum(NOS)/sum(TOTAL <CLASS> NOS)

In the Number Tab -> Fixed to -> 0  and Show in Percent (%)

[sunny_talwar]

How will you get this result with the above expression Settu Periasamy‌

B	187	96%
B	8	4%
B	195	100%
B	1,175	94%
B	77	6%
B	0	0%
B	1	0%
B	1,253	100%

[upaliwije]

THANKS

But it does not produce the results

[settu_periasamy]

Just i assumed, he have another one dimension in his chart. 🙂  May be like B1 and B2

[settu_periasamy · Accepted solution]

can you post your sample data?

Just i created the sample based on your input..

check the attachment..