topic Re: % AGAINST TOTAL in QlikView

% AGAINST TOTAL

upaliwije — Thu, 21 Jan 2016 16:45:30 GMT

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

Re: % AGAINST TOTAL

sunny_talwar — Thu, 21 Jan 2016 16:48:00 GMT

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

Re: % AGAINST TOTAL

upaliwije — Thu, 21 Jan 2016 16:50:21 GMT

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

Re: % AGAINST TOTAL

sunny_talwar — Thu, 21 Jan 2016 16:54:04 GMT

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 .

Re: % AGAINST TOTAL

upaliwije — Thu, 21 Jan 2016 16:58:18 GMT

Thanks

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

Re: % AGAINST TOTAL

settu_periasamy — Thu, 21 Jan 2016 17:05:41 GMT

Try Like this..

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

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

Re: % AGAINST TOTAL

sunny_talwar — Thu, 21 Jan 2016 17:07:54 GMT

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%

Re: % AGAINST TOTAL

upaliwije — Thu, 21 Jan 2016 17:13:40 GMT

THANKS

But it does not produce the results

Re: % AGAINST TOTAL

settu_periasamy — Thu, 21 Jan 2016 17:20:21 GMT

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

Re: % AGAINST TOTAL

settu_periasamy — Thu, 21 Jan 2016 17:21:48 GMT

can you post your sample data?

Just i created the sample based on your input..

check the attachment..

Re: % AGAINST TOTAL

sunny_talwar — Thu, 21 Jan 2016 17:22:01 GMT

Yes, if that is true then it can work

Re: % AGAINST TOTAL

upaliwije — Fri, 22 Jan 2016 03:22:02 GMT

Thanks

It is working

Re: % AGAINST TOTAL

settu_periasamy — Fri, 22 Jan 2016 03:25:21 GMT

Good.

Can you close this thread to mark it as Correct or Helpful answer ?

Re: % AGAINST TOTAL

upaliwije — Fri, 22 Jan 2016 03:29:21 GMT

Sorry

I forgot it. Now done

Re: % AGAINST TOTAL

settu_periasamy — Fri, 22 Jan 2016 03:31:18 GMT

No Problem upaliwije.