topic Re: %row level( looking for Horizontal level ) in QlikView

%row level( looking for Horizontal level )

Mon, 23 May 2016 13:16:33 GMT

Hi All,

A	B	C	D	A%	B%	C%	D%
410	2	11	21	92%	0%	2%	5%
412	13	32	431	46%	1%	4%	49%
425	45	463	843	24%	3%	26%	47%

I could able to achieve Vertical level % instead of Horizontal level %.

Could any help me in solving the Horizontal level percentage issue.

Regards,

SJBI

Re: %row level

sunny_talwar — Mon, 23 May 2016 13:33:09 GMT

What is your expression right now and what object are you using?

Re: %row level

Mon, 23 May 2016 13:35:14 GMT

I explain you my business requirement. There are 4 risk category in each branch. Want to see the at what % each risk is. Hope you understand.

Re: %row level

Mon, 23 May 2016 13:43:11 GMT

Current expression is

ex;

a/sum(a,b,c,d),

I'm not using any kind of calculations at Script level. All the calculation are done at Application level only.

Re: %row level( looking for Horizontal level )

sunny_talwar — Mon, 23 May 2016 15:29:49 GMT

May be try this:

a/Sum(TOTAL a),

b/Sum(TOTAL b),

...

Re: %row level( looking for Horizontal level )

Tue, 24 May 2016 06:58:33 GMT

Thank you can u explain me where to use the formula. When I try to use the formula its taking vertical level Grand Total and doing the calculation. Could you let me know where I'm missing..

A	B	C	D	A%	B%	C%	D%
410	2	11	21	92%	0%	2%	5%
412	13	32	431	46%	1%	4%	49%
425	45	463	843	24%	3%	26%	47%

This is how my must look like. To right side columns(A,B,C,D) its the % level. As of now we are using EXCEL %rowlevel using Pivot.

A%=A /sum(A,B,C,D).

Regards

Re: %row level( looking for Horizontal level )

Anonymous — Tue, 24 May 2016 09:07:27 GMT

use expression as : A% = A/(A+B+C+D)

Re: %row level( looking for Horizontal level )

sunny_talwar — Tue, 24 May 2016 09:10:53 GMT

I have attached the sample to get this in QlikView

Re: %row level( looking for Horizontal level )

Anonymous — Tue, 24 May 2016 09:15:12 GMT

Forgot to attach .

Please see this .

Re: %row level( looking for Horizontal level )

Tue, 24 May 2016 09:52:46 GMT

Thank you for your reply. Attaching my data.

Re: %row level( looking for Horizontal level )

Tue, 24 May 2016 12:15:37 GMT

Thank you for you help I used the formula

sum(XX)/sum(TOTAL <YY>XX).

My issue is solved Thank you every one.

A	B	C	D	A%	B%	C%	D%
410	2	11	21	92%	0%	2%	5%
412	13	32	431	46%	1%	4%	49%
425	45	463	843	24%	3%	26%	47%

A	B	C	D	A%	B%	C%	D%
410	2	11	21	92%	0%	2%	5%
412	13	32	431	46%	1%	4%	49%
425	45	463	843	24%	3%	26%	47%

A	B	C	D	A%	B%	C%	D%
410	2	11	21	92%	0%	2%	5%
412	13	32	431	46%	1%	4%	49%
425	45	463	843	24%	3%	26%	47%

A	B	C	D	A%	B%	C%	D%
410	2	11	21	92%	0%	2%	5%
412	13	32	431	46%	1%	4%	49%
425	45	463	843	24%	3%	26%	47%

A	B	C	D	A%	B%	C%	D%
410	2	11	21	92%	0%	2%	5%
412	13	32	431	46%	1%	4%	49%
425	45	463	843	24%	3%	26%	47%

A	B	C	D	A%	B%	C%	D%
410	2	11	21	92%	0%	2%	5%
412	13	32	431	46%	1%	4%	49%
425	45	463	843	24%	3%	26%	47%