https://community.qlik.com/t5/QlikView/Chart-line-based-on-selection/m-p/1704263#M725562 <P>See duplicate post:&nbsp;<A href="https://community.qlik.com/t5/New-to-QlikView/The-average-on-chart/m-p/1697945#M388628" target="_blank">https://community.qlik.com/t5/New-to-QlikView/The-average-on-chart/m-p/1697945#M388628</A></P><P>Regards,<BR />Brett</P> Thu, 21 May 2020 21:36:27 GMT Brett_Bleess 2020-05-21T21:36:27Z https://community.qlik.com/t5/QlikView/Chart-line-based-on-selection/m-p/1697915#M725561 <P>Dears,&nbsp;</P><P>&nbsp;</P><P>I have one table with the [Company Name], [Sector] and [Date], example:</P><P>[Company Name] - [Sector] - [Date]<BR />United - Airlines - 01/01/2020<BR />Amazon - Internet - 02/02/2020<BR />American Airlines - Airlines - 02/01/2020<BR />Best Buy - Internet - 03/05/2019</P><P>I have a list containing just the [Company Name], in this case<BR />United<BR />Amazon<BR />American Airlines<BR />Best Buy</P><P>And have a chart with Dates as Dimension and the following 2 expressions:</P><OL><LI>=sum(Volume)&nbsp;</LI><LI>=sum(Closing)</LI></OL><P>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.</P><P>&nbsp;</P><P>How can I do it?</P><P>Thanks</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Chart-line-based-on-selection/m-p/1697915#M725561 brunolelli87 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Chart-line-based-on-selection/m-p/1704263#M725562 <P>See duplicate post:&nbsp;<A href="https://community.qlik.com/t5/New-to-QlikView/The-average-on-chart/m-p/1697945#M388628" target="_blank">https://community.qlik.com/t5/New-to-QlikView/The-average-on-chart/m-p/1697945#M388628</A></P><P>Regards,<BR />Brett</P> Thu, 21 May 2020 21:36:27 GMT https://community.qlik.com/t5/QlikView/Chart-line-based-on-selection/m-p/1704263#M725562 Brett_Bleess 2020-05-21T21:36:27Z