% Calculation issues in Qlikview

[nishantrft]

Hi team,

Attached the sample qvw and excel data which i was working on.

I have 4 dimensions in my Pivot chart and i need to calculate % of each column against its partial Total.

eg: 85/105 i should get 80.00% instead QV result is 20%. I have attached the qvw /excel and error % screenshot. Can any one help on this.

My set analysis is like this.

Sum(Amt)

/

Sum

(

TOTAL (Amt)

)

DATA

BSClass	GSIB	Enrich	Sector	Amt
Asset	C&B	Yes	banks	10
Asset	C&B	Yes	banks	20
Asset	Other	Yes	banks	40
Asset	Other	Yes	banks	50
Asset	Fross	Yes	banks	40
Asset	Fross	Yes	banks	50
Asset	C&B	Yes	banks	55
Asset	C&B	Yes	Gov	20
Asset	Other	Yes	Gov	40
Asset	Other	Yes	Household	50
Asset	Fross	Yes	Household	15
Asset	Fross	Yes	Household	40

Advance Thanks

Nishant

[trdandamudi]

Attachment is missing ?

[vishsaggi]

Try this for your % expr

= Sum(Amt)/Sum(TOTAL <GSIB> Amt)

[nevilledhamsiri]

Check This

Neville