topic How to sum an average in a pivot table in QlikView

How to sum an average in a pivot table

Sun, 01 Jul 2012 19:36:17 GMT

How can you sum an average in a pivot table

I have a colom named FTE

this values come with the formule avg (FTE)

Only the subtotal is now 1 but i want to see 5. A sum of (FTE) doesnt work i must work with the average.

Thank You

Re: How to sum an average in a pivot table

giakoum — Sun, 01 Jul 2012 20:02:52 GMT

Can you use a straight table instead of a pivot? There you can use sum of rows for the avg expression.

Re: How to sum an average in a pivot table

Anonymous — Sun, 01 Jul 2012 20:03:49 GMT

Not quite clear because you didn't specify the dimensions. But in general it may look like this:

sum(aggr(avg (FTE),dimensionfield))

Regards,

Michael

Edit: If there are multiple dimensions there, use all, comma-separated, instead of the dimensionfield above.

Re: How to sum an average in a pivot table

Anonymous — Sun, 01 Jul 2012 21:30:54 GMT

The Pivot Table does not cater for the average function on the Rows (this is coming in QV 11).

If you even try to 'fool' the chart by first making it a normal chart table with the average of the rows option enabled and then changing that chart to a pivot table, the totals will always be a straight total. As per other posts, your best bet is to use a normal chart table format.