Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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