https://community.qlik.com/t5/QlikView/The-average-on-chart/m-p/1698045#M725534 <P>Thank you so much!</P><P>It's exactly what I'm looking for...</P> Thu, 30 Apr 2020 09:56:27 GMT brunolelli87 2020-04-30T09:56:27Z https://community.qlik.com/t5/QlikView/The-average-on-chart/m-p/1697945#M725532 <P>Hello guys,&nbsp;</P><P>&nbsp;</P><P>How can I add a new line on my chart, to show the average prices of a group belonging to the selected company?</P><P>&nbsp;</P><P>I have a list where the user can select a Company.<BR />But each company belongs to a specific group, so I would like to show on a chart the comparison between the company's price and its group.</P><P>&nbsp;</P><P>How can I do it?<BR />Thanks</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/The-average-on-chart/m-p/1697945#M725532 brunolelli87 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/The-average-on-chart/m-p/1697971#M725533 <P>hi&nbsp;</P><P>you can achieve this with something like this ,</P><LI-CODE lang="markup">avg({&lt;Company,Group=p(Group)&gt;}price)</LI-CODE><P>&nbsp;</P> Thu, 30 Apr 2020 05:52:01 GMT https://community.qlik.com/t5/QlikView/The-average-on-chart/m-p/1697971#M725533 lironbaram 2020-04-30T05:52:01Z https://community.qlik.com/t5/QlikView/The-average-on-chart/m-p/1698045#M725534 <P>Thank you so much!</P><P>It's exactly what I'm looking for...</P> Thu, 30 Apr 2020 09:56:27 GMT https://community.qlik.com/t5/QlikView/The-average-on-chart/m-p/1698045#M725534 brunolelli87 2020-04-30T09:56:27Z