topic Re: create a average in pivot table in QlikView

create a average in pivot table

kumarkp412 — Wed, 25 Mar 2015 07:36:11 GMT

Hi friends ,

Is it possible to create to averages in the pivot table?

In the pivot table properties , it is having total and partial sum of the dimension.i didn't fine any other option to get the average.

Is that we have to create a expression to get the average of the columns?

can any one give me one example ?

Thanks in advance

Kumar

giakoum — Wed, 25 Mar 2015 07:38:42 GMT

kumarkp412 — Wed, 25 Mar 2015 08:02:16 GMT

Hi ioannis,

thanks for reply,

but in the pivot table this option is not available,

Thanks
Kumar

giakoum — Wed, 25 Mar 2015 08:11:12 GMT

try changing it to straight, enable the option and then back to pivot

jonathandienst — Wed, 25 Mar 2015 08:33:34 GMT

In a pivot table, you will need an Aggr expression of the form:

=Avg(Aggr(<your current expression>, <your table dimensions>))

Where <your current expression> is the expression that you want the average of.
<your table dimensions>is a comma separated list of the fields in all the table dimensions

For example

=Avg(Aggr(Sum(Expenses)/Sum(Sales), Year, Month, Day, Division))

HTH

Jonathan