Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
tracycrown
Contributor II

Average

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 

2 Solutions

Accepted Solutions
Frank_Hartmann
Honored Contributor

Re: Average

try this:

avg(Total Price*Quantity)
Frank_Hartmann
Honored Contributor

Re: Average

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!
3 Replies
Frank_Hartmann
Honored Contributor

Re: Average

try this:

avg(Total Price*Quantity)
tracycrown
Contributor II

Re: Average

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 

 

 

Frank_Hartmann
Honored Contributor

Re: Average

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!
Community Browser