% Calculation issues in Qlikview

nishantrft — Wed, 25 Nov 2020 16:16:04 GMT

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

Advance Thanks

Nishant

Re: % Calculation issues in Qlikview

trdandamudi — Wed, 26 Sep 2018 14:00:12 GMT

Attachment is missing ?

vishsaggi — Wed, 26 Sep 2018 14:25:41 GMT

Try this for your % expr

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

nevilledhamsiri — Wed, 26 Sep 2018 18:13:58 GMT

Check This

Neville