topic Re: Question about an avg in pivottable in QlikView

Question about an avg in pivottable

francisvandergr — Tue, 16 Jun 2015 13:54:51 GMT

I have a pivottable with the dimensions year and period. At the end i want an total (avg of 3 years).

Because i want one column i have used an dimension. Otherwise i get for every year an avg,

My formula for the dimension is : =aggr(avg(Turnover),Period)

I want tghis formula with set analyses. I wanna have only Account 10 in m y calculation is this possible. I have included an example.

giakoum — Tue, 16 Jun 2015 13:58:11 GMT

aggr(avg({<aCCOUNT={"10"}>} Turnover),Period)

swuehl — Tue, 16 Jun 2015 14:00:29 GMT

Maybe like attached?

francisvandergr — Tue, 16 Jun 2015 15:12:12 GMT

Sorry Swuehl. I wanna have both. So i wanna have a subtotal and i wanna have an Average. Can i do something with an dimension ?

swuehl — Tue, 16 Jun 2015 15:23:51 GMT

You want it more like this?

francisvandergr — Tue, 16 Jun 2015 15:36:33 GMT

Top!