https://community.qlik.com/t5/QlikView/Expression-Help-Please/m-p/1652761#M730428 <P>I'm after some hep with the syntax for an expression in a chart please?</P><P>I have three dimensions:</P><P>Period, Account and GLActual</P><P>I'd like to construct a combo chart with two expressions:</P><P>Sum(GLActual) as a column, which I can do no problem <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>I would then like a flat line which shows 80%&nbsp;of the average of the sum of selcted periods, please see examples below where Series 1 is the basic actual sum and series 2 the 80% average of the cumulatie:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="example.PNG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/24679iF247AB83D9CAF87A/image-size/large?v=v2&amp;px=999" role="button" title="example.PNG" alt="example.PNG" /></span></P><P>Any help would be greatly appreciated.</P> Wed, 25 Nov 2020 16:16:04 GMT jameswills 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Expression-Help-Please/m-p/1652761#M730428 <P>I'm after some hep with the syntax for an expression in a chart please?</P><P>I have three dimensions:</P><P>Period, Account and GLActual</P><P>I'd like to construct a combo chart with two expressions:</P><P>Sum(GLActual) as a column, which I can do no problem <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>I would then like a flat line which shows 80%&nbsp;of the average of the sum of selcted periods, please see examples below where Series 1 is the basic actual sum and series 2 the 80% average of the cumulatie:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="example.PNG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/24679iF247AB83D9CAF87A/image-size/large?v=v2&amp;px=999" role="button" title="example.PNG" alt="example.PNG" /></span></P><P>Any help would be greatly appreciated.</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Expression-Help-Please/m-p/1652761#M730428 jameswills 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Expression-Help-Please/m-p/1652764#M730429 <P>May be this</P><LI-CODE lang="markup">Avg(TOTAL Aggr(Sum(GLActual), Period)) * 0.80</LI-CODE> Fri, 29 Nov 2019 16:17:53 GMT https://community.qlik.com/t5/QlikView/Expression-Help-Please/m-p/1652764#M730429 sunny_talwar 2019-11-29T16:17:53Z