Solved: Re: Calculating Average - Qlik Community

Report Inappropriate Content · ‎2015-03-20

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?

Report Inappropriate Content · ‎2015-03-20

Hi,

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

and you can use in

Dimension tab: Products

Expression tab: Avg(Price)

View solution in original post

amit_saini · ‎2015-03-20

hi,

Check below:

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

Thanks,
AS

PrashantSangle · ‎2015-03-20

Hi,

USe Sum(Price)/Sum(Distinct Product)

or simply use Avg(Price)

Better you give us sample data with required output.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

prajuds99 · ‎2015-03-20

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.

Report Inappropriate Content · ‎2015-03-20

Hi,

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

and you can use in

Dimension tab: Products

Expression tab: Avg(Price)

Report Inappropriate Content · ‎2015-03-20

Thanks guys! That answers my question.

Thought it would be more complex than this though.