topic Re: Average over period sum in QlikView

Average over period sum

Thu, 20 Nov 2014 12:50:17 GMT

Hi, i have the following table for example

test:

load * inline [

period, branch, salesAmount

201401, 1 , 1000

201402, 2 , 1200

201312, 1 , 1400

201312, 2 , 1000

201311, 1 , 800

201402, 1 , 1050

];

i wish to calculate average of period sum sales amount. i'm looking for some examples and i've found Aggr(Total ...) function, but i don't understand totally how it works.

In this case it should be 1612,5

thanks!

Re: Average over period sum

rubenmarin — Thu, 20 Nov 2014 12:56:19 GMT

Hi, try:

=Avg(Aggr(Sum(salesAmount), period))

Re: Average over period sum

veidlburkhard — Thu, 20 Nov 2014 13:00:25 GMT

Hi Alexander,

simply use: Sum(salesAmount) / Count(DISTINCT period)

Hope this helps

Burkhard

Re: Average over period sum

Thu, 20 Nov 2014 13:02:10 GMT

Thank you very much, it was i've been looking for.

Re: Average over period sum

Thu, 20 Nov 2014 13:07:17 GMT

Thanks Burkhard, but my real expresion is so complex and Aggr is more simple for read, this data was only to show you that i want to make.

Regards!