Chart line based on selection

[brunolelli87]

Dears, 

I have one table with the [Company Name], [Sector] and [Date], example:

[Company Name] - [Sector] - [Date]
United - Airlines - 01/01/2020
Amazon - Internet - 02/02/2020
American Airlines - Airlines - 02/01/2020
Best Buy - Internet - 03/05/2019

I have a list containing just the [Company Name], in this case
United
Amazon
American Airlines
Best Buy

And have a chart with Dates as Dimension and the following 2 expressions:

1. =sum(Volume) 
2. =sum(Closing)

I would like to create another expression representing the average of closing of the [Sector] belonged to the company selected by the user on the list.

How can I do it?

Thanks

[Brett_Bleess · Accepted solution]

See duplicate post: https://community.qlik.com/t5/New-to-QlikView/The-average-on-chart/m-p/1697945#M388628

Regards,
Brett