topic Average in QlikView

Average

tracycrown — Wed, 25 Nov 2020 16:16:04 GMT

Dear all

I would like to set the average column equal to average of column(3) (ie $677.59), kindly advise how to write the formula.

Thank you

Tracy

Re: Average

Frank_Hartmann — Thu, 06 Dec 2018 08:18:23 GMT

try this:

avg(Total Price*Quantity)

Re: Average

tracycrown — Fri, 07 Dec 2018 02:14:40 GMT

Dear Frank_Hartmann

Many thanks for your quick response.

Kindly advise why avg (total column(3)) is not working as it is the same as avg(total Price*Quantity).

Also, how to make avg(total column(3)) work, am I missing anything ?

Thank you

Tracy

Re: Average

Frank_Hartmann — Fri, 07 Dec 2018 08:32:43 GMT

No, you are not missing anything. You just cannot use column function in this case!
The Column() function operates on a strictly row-by-row basis.
You will have to use the proposed formula in order to achieve your output!

hope this helps!