topic Re: Trendline on stacked chart in QlikView https://community.qlik.com/t5/QlikView/Trendline-on-stacked-chart/m-p/1312437#M842638 <HTML><HEAD></HEAD><BODY><P>Have a look at the attached link:</P><P></P><P><A href="https://community.qlik.com/message/1156344">Re: Forecast Calculation</A></P><P></P><P>Andy</P></BODY></HTML> Tue, 25 Apr 2017 15:47:17 GMT awhitfield 2017-04-25T15:47:17Z Trendline on stacked chart https://community.qlik.com/t5/QlikView/Trendline-on-stacked-chart/m-p/1312431#M842632 <HTML><HEAD></HEAD><BODY><P>Hey all,</P><P></P><P>I need some help:</P><P></P><P>I have a bar chart showing my opportunities revenues over time.</P><P></P><P>I have also added a reference line to this chart to 800.000 € that represents my yearly target.</P><P></P><P>I would like to create another reference line that goes from 0 to 800.000€ in December.</P><P></P><P>Can you please help me on this because i cant find any resource to help me.</P><P></P><P>Thank you in advance.</P><P></P><P>Arnaud</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Trendline-on-stacked-chart/m-p/1312431#M842632 Anonymous 2020-11-25T16:16:04Z Re: Trendline on stacked chart https://community.qlik.com/t5/QlikView/Trendline-on-stacked-chart/m-p/1312432#M842633 <HTML><HEAD></HEAD><BODY><P>Hi Arnaud,</P><P>Did you try adding it from the 'Reference Line' section in the presentation tab?</P><P>You can add an expressions, conditions, according to your requirement.</P><P></P><P><IMG alt="1.PNG" class="jive-image image-1" height="323" src="https://community.qlik.com/legacyfs/online/161137_1.PNG" style="height: 323.046px; width: 361px;" width="361" /></P><P><IMG alt="2.PNG" class="jive-image image-2" height="312" src="https://community.qlik.com/legacyfs/online/161138_2.PNG" style="height: 311.816px; width: 345px;" width="345" /></P></BODY></HTML> Tue, 25 Apr 2017 10:07:29 GMT https://community.qlik.com/t5/QlikView/Trendline-on-stacked-chart/m-p/1312432#M842633 chhavi376 2017-04-25T10:07:29Z Re: Trendline on stacked chart https://community.qlik.com/t5/QlikView/Trendline-on-stacked-chart/m-p/1312433#M842634 <HTML><HEAD></HEAD><BODY><P>Yes i tried, but i think its more an expression problem because i don't know how to express a trendline starting from 0 and ending in december at 800.000€</P></BODY></HTML> Tue, 25 Apr 2017 11:00:30 GMT https://community.qlik.com/t5/QlikView/Trendline-on-stacked-chart/m-p/1312433#M842634 Anonymous 2017-04-25T11:00:30Z Re: Trendline on stacked chart https://community.qlik.com/t5/QlikView/Trendline-on-stacked-chart/m-p/1312434#M842635 <HTML><HEAD></HEAD><BODY><P>Hello, </P><P></P><P>Could you post a sample data?</P></BODY></HTML> Tue, 25 Apr 2017 12:40:59 GMT https://community.qlik.com/t5/QlikView/Trendline-on-stacked-chart/m-p/1312434#M842635 Anonymous 2017-04-25T12:40:59Z Re: Trendline on stacked chart https://community.qlik.com/t5/QlikView/Trendline-on-stacked-chart/m-p/1312435#M842636 <HTML><HEAD></HEAD><BODY><P>Find here attached an example.</P><P></P><P>On this chart, i would like to display a fixed reference line that goes from 0 in January 2010 to the other reference line (4500) in december 2010.</P><P></P><P>I think that my main problem is to define the expression to create the reference line.</P><P></P><P>Best regards</P></BODY></HTML> Tue, 25 Apr 2017 12:50:12 GMT https://community.qlik.com/t5/QlikView/Trendline-on-stacked-chart/m-p/1312435#M842636 Anonymous 2017-04-25T12:50:12Z Re: Trendline on stacked chart https://community.qlik.com/t5/QlikView/Trendline-on-stacked-chart/m-p/1312436#M842637 <HTML><HEAD></HEAD><BODY><P>Have you had a play about with Trend lines on he Expressions tab?</P><P></P><P>Andy</P></BODY></HTML> Tue, 25 Apr 2017 13:55:48 GMT https://community.qlik.com/t5/QlikView/Trendline-on-stacked-chart/m-p/1312436#M842637 awhitfield 2017-04-25T13:55:48Z Re: Trendline on stacked chart https://community.qlik.com/t5/QlikView/Trendline-on-stacked-chart/m-p/1312437#M842638 <HTML><HEAD></HEAD><BODY><P>Have a look at the attached link:</P><P></P><P><A href="https://community.qlik.com/message/1156344">Re: Forecast Calculation</A></P><P></P><P>Andy</P></BODY></HTML> Tue, 25 Apr 2017 15:47:17 GMT https://community.qlik.com/t5/QlikView/Trendline-on-stacked-chart/m-p/1312437#M842638 awhitfield 2017-04-25T15:47:17Z Re: Trendline on stacked chart https://community.qlik.com/t5/QlikView/Trendline-on-stacked-chart/m-p/1312438#M842639 <HTML><HEAD></HEAD><BODY><P>Dear Andrew,</P><P></P><P>Thank you for your input but i think that my main problem is to define the expression of the reference line.</P><P></P><P>It should be a line going from 0 to december - 4500€ (cf the QV sample posted above).</P><P></P><P>Thank you in advance for your help.</P></BODY></HTML> Wed, 26 Apr 2017 09:01:25 GMT https://community.qlik.com/t5/QlikView/Trendline-on-stacked-chart/m-p/1312438#M842639 Anonymous 2017-04-26T09:01:25Z