topic Pivot table totals in QlikView

Pivot table totals

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

Hi all,

I have a pivot table with 3 dimensions as describe in the "Pivot" picture

The values of the expression are calculated by the following if

if(Comp='A' and Process='R',Value/$(v_A_H_R)*$(v_Volatility_R),
if(Comp='B' and Process='R',Value/$(v_B_H_R)*$(v_Volatility_R),
if(Comp='A' and Process='P',Value/$(v_A_H_P)*$(v_Volatility_P),

if(Comp='B' and Process='P',Value/$(v_B_H_P)*$(v_Volatility_P),
if(Comp='A' and Process='D',Value/$(v_A_H_D)*$(v_Volatility_D),
if(Comp='B' and Process='D',Value/$(v_B_H_D)*$(v_Volatility_D)
)))))))

When I checked the "Show Partial Sums"

For the "Description" and "Comp" Dimensions

I received "-" (Nulls) for the Totals

I also attached the data file

There is a way to calculate and present the totals as I did in the Goal picture?

Re: Pivot table totals

tincholiver — Wed, 13 Mar 2019 15:56:51 GMT

I do not know if I understand your problem well;
the totals are null because there are no values for those dimensions, what number do you hope to achieve?
Did you try putting sum at the beginning of the expression?

Re: Pivot table totals

shahafei2 — Thu, 14 Mar 2019 06:57:36 GMT

hI tncholiver,

I would like to receive the totals of each row and each column as I draw in the Goal.Jpg (In yellow)