Calculating Average

[#1]

Hi All

I have fields [Products] and [Price]. I would like to calculate the average price per product.

Which formula or function can I use for this?

[amit_saini]

hi,

Check below:

http://community.qlik.com/blogs/qlikviewdesignblog/2013/07/29/averages

Thanks,
AS

[PrashantSangle]

Hi,

USe Sum(Price)/Sum(Distinct Product)

or simply use Avg(Price)

Better you give us sample data with required output.

Regards

[prajuds99]

Hi Stewart

You can use Avg() function for this.

You can write it as Avg(Price) in the chart expression in case you are using a chart.

[#5 · Accepted solution]

Hi,

Go to New sheet object -->> Charts-->> Bar chart.

and  you can use in

                 Dimension tab: Products

                 Expression tab: Avg(Price)

[#6]

Thanks guys! That answers my question.

Thought it would be more complex than this though.