topic Custom trendline using set expression in Water Cooler https://community.qlik.com/t5/Water-Cooler/Custom-trendline-using-set-expression/m-p/364157#M1113 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a chart that shows YTD actuals by month (so now you'd see 4 columns, Jan to April) and I'd like to show a trendline for average full-year forecast, which would involve a set expression like sum({$&lt;Scenario = {'Forecast'}, Year = {$(CurrentYear)}, Month = {12}&gt;} YTDCOST).&nbsp; I can't seem to get it to display correctly, maybe because it references a completely different set of data than the Actuals bars.&nbsp; Any help would be appreciated (doesn't have to be represented exactly this way, just want average FY forecast and YTD actuals by month on the same chart somehow).</P><P></P><P>Thanks</P><P>Justin</P></BODY></HTML> Mon, 23 Apr 2012 17:51:08 GMT 2012-04-23T17:51:08Z Custom trendline using set expression https://community.qlik.com/t5/Water-Cooler/Custom-trendline-using-set-expression/m-p/364157#M1113 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a chart that shows YTD actuals by month (so now you'd see 4 columns, Jan to April) and I'd like to show a trendline for average full-year forecast, which would involve a set expression like sum({$&lt;Scenario = {'Forecast'}, Year = {$(CurrentYear)}, Month = {12}&gt;} YTDCOST).&nbsp; I can't seem to get it to display correctly, maybe because it references a completely different set of data than the Actuals bars.&nbsp; Any help would be appreciated (doesn't have to be represented exactly this way, just want average FY forecast and YTD actuals by month on the same chart somehow).</P><P></P><P>Thanks</P><P>Justin</P></BODY></HTML> Mon, 23 Apr 2012 17:51:08 GMT https://community.qlik.com/t5/Water-Cooler/Custom-trendline-using-set-expression/m-p/364157#M1113 2012-04-23T17:51:08Z