topic Re: Average on a horizontal pivot table in QlikView

Average on a horizontal pivot table

QlikMo — Wed, 09 Nov 2022 10:14:34 GMT

Hi,

Can anyone help. I am trying to get an average of all months at the end of the table. I have read other posts about using the dimensionality() function but no matter what I do I can't seem to get the intended result. Could someone advise?

Thanks

Re: Average on a horizontal pivot table

rubenmarin — Wed, 09 Nov 2022 10:57:32 GMT

Hi, PFA.

Crete the month field in script to use in aggr.

Check partial sums for month.

Use SecondaryDimensionality() instead of Dimensionality()

2 options for Avg, I created 2 tables.

Re: Average on a horizontal pivot table

QlikMo — Wed, 09 Nov 2022 12:04:02 GMT

Thank you very much