topic Re: Total sum of average values in QlikView

Total sum of average values

Fri, 26 Feb 2016 08:57:58 GMT

Hi,

I have a pivot table with only one dimension and only one expression.

The expression consist of an average, =AVG(field)

When I check the checkbox 'Show partial sums' in the tag 'presentation' it shows a total which is an average but I need a sum of the averages in the table.

How could I get this total as a sum?

Thanks.

Re: Total sum of average values

Fri, 26 Feb 2016 09:09:12 GMT

Hi ,

Try using this expression sum(Aggr( Avg(field),dimension field))

Regards

Re: Total sum of average values

jagan — Fri, 26 Feb 2016 09:09:48 GMT

HI,

Try like this

=Sum(Aggr(Avg(Field), DimensionName))

Regards,

Jagan.

Re: Total sum of average values

tamilarasu — Fri, 26 Feb 2016 09:09:52 GMT

Hi Luis,

Try,

If(Dimensionality()=0,Sum(Field),Avg(Field))

Re: Total sum of average values

MayilVahanan — Fri, 26 Feb 2016 09:17:17 GMT

Try like this

=Sum(Aggr(Avg(FieldName), DimensionName))

Re: Total sum of average values

luciancotea — Fri, 26 Feb 2016 09:31:30 GMT

Well, it's unusual to display the sum of averages... but here you go:

Since you can't change the total expression to "Sum of rows" like in a straight table, you could check the level of aggregation using DIMENSIONALITY(). See the help on using it.

Or, you could switch to straight table and change the expression total calculation mode.