topic Average aggregation in QlikView

Average aggregation

Thu, 14 Jan 2016 13:35:45 GMT

Hey,

I have build an easy example. On the left part you will see 2 textboxes with the right result and on the right part you will see aggr function. But the aggr function is wrong. How I must change these aggr function that you got the right result like in the left part?

Thank you

Re: Average aggregation

sunny_talwar — Thu, 14 Jan 2016 13:40:58 GMT

Try these:

=Avg(Aggr(Sum(Tore), Spieler))

=Avg(Aggr(Sum(Tore), Verein))

Re: Average aggregation

jonathandienst — Thu, 14 Jan 2016 13:42:13 GMT

Its not clear what you are trying to do with the Aggr function. Why do you want to "change these aggr function that you got the right result like in the left part?"

Aggr() is usually used for calculated dimensions, sum of rows and nested aggregations and should only be used if necessary as it is memory intensive.