Pivot Table, average expression and Sum

shayraber — Sun, 09 Aug 2015 11:14:17 GMT

Hi all,

I have a two dimensional pivot table, one positioned vertically and the second one (months) positioned horizontally.

the expression is a simple "Avg({<...>}....)". the option of partial sum returns an average of the values (as the expression itself). is there a way of implementing a partial sum which return a SUM of the average values?

for example, the partial sums will return 10 (as the average of a series of 10s) instead of 100 which is the sum of ten items with the value of 10

item	Period
a	10
b	10
c	10
d	10
e	10
f	10
g	10
h	10
i	10
j	10
Total	10

Re: Pivot Table, average expression and Sum

lironbaram — Sun, 09 Aug 2015 12:35:50 GMT

you can do it using aggr function

something like , sum(aggr(avg(),Item,Month))

Re: Pivot Table, average expression and Sum

jafari_ervin — Sun, 09 Aug 2015 12:44:12 GMT

This attachment maybe useful.

topic Re: Pivot Table, average expression and Sum in QlikView

Pivot Table, average expression and Sum

Re: Pivot Table, average expression and Sum

Re: Pivot Table, average expression and Sum