topic Re: Partial average in pivot table in QlikView

Partial average in pivot table

Wed, 25 Nov 2020 16:16:04 GMT

Good afternoon everyone! I have been trying unsuccessfully to get a partial average (instead of partial sums) on the dimension "Month" as shown in the pivot table shown below. Hope anyone can help. Thanks in advance.

Re: Partial average in pivot table

sunny_talwar — Tue, 04 Oct 2016 15:38:19 GMT

Have you tried

Avg(Aggr(YourExpression, METRIC, Year, Month))

Re: Partial average in pivot table

Wed, 05 Oct 2016 02:07:28 GMT

Sunny,

Tried that, both as a calculated dimension and as expression, an error message appears.

Re: Partial average in pivot table

jyothish8807 — Wed, 05 Oct 2016 13:58:26 GMT

Hi Maria,

Is this what your looking for ?

Regards

Re: Partial average in pivot table

sunny_talwar — Wed, 05 Oct 2016 15:25:44 GMT

I think this is what you need to try as an expression:

Avg(Aggr(Sum([Total MRCPhP]), METRIC, Year, Month))

I think you forgot to add Sum() when you used this has expression

Re: Partial average in pivot table

Thu, 06 Oct 2016 01:29:58 GMT

KC,

sorry, can you re-send? can't seem to see your attachment.

Re: Partial average in pivot table

sunny_talwar — Thu, 06 Oct 2016 15:35:15 GMT

Open this link to see the attachment:

Re: Partial average in pivot table

Fri, 07 Oct 2016 00:15:07 GMT

Sunny,

thanks for the link. unfortunately, I am using personal edition so I can't open it....

Re: Partial average in pivot table

Fri, 07 Oct 2016 01:09:35 GMT

Will try your suggestion, thanks.