topic Re: Calculating Average in QlikView

Calculating Average

Fri, 20 Mar 2015 06:55:48 GMT

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 — Fri, 20 Mar 2015 06:58:55 GMT

hi,

Check below:

Thanks,
AS

PrashantSangle — Fri, 20 Mar 2015 06:59:22 GMT

Hi,

USe Sum(Price)/Sum(Distinct Product)

or simply use Avg(Price)

Better you give us sample data with required output.

Regards

prajuds99 — Fri, 20 Mar 2015 07:01:34 GMT

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.

Fri, 20 Mar 2015 07:07:11 GMT

Hi,

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

and you can use in

Dimension tab: Products

Expression tab: Avg(Price)

Fri, 20 Mar 2015 07:25:56 GMT

Thanks guys! That answers my question.

Thought it would be more complex than this though.