%row level( looking for Horizontal level )

[#1]

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

[sunny_talwar]

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

[#3]

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.

[#4]

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. 

[sunny_talwar]

May be try this:

a/Sum(TOTAL a),

b/Sum(TOTAL b),

...

[#6]

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

[Anonymous]

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

[sunny_talwar]

I have attached the sample to get this in QlikView

[Anonymous]

Forgot to attach .

Please see this .

[#10]

Thank you for your reply. Attaching my data.