Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculating Average


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?

1 Solution

Accepted Solutions
Not applicable
Author

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

5 Replies
amit_saini
Master III
Master III

PrashantSangle

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
Contributor II
Contributor II

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.

Not applicable
Author

Hi,

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

and  you can use in

                 Dimension tab: Products

                 Expression tab: Avg(Price)

Not applicable
Author

Thanks guys! That answers my question.

Thought it would be more complex than this though.