topic Re: Make a diagonal, linear reference line for accumulated values in App Development https://community.qlik.com/t5/App-Development/Make-a-diagonal-linear-reference-line-for-accumulated-values/m-p/1364667#M30713 <HTML><HEAD></HEAD><BODY><P>On chart properties&gt;Presentation&gt;right bottom&gt;under reference lines you can add it</P></BODY></HTML> Wed, 31 May 2017 09:50:23 GMT tajmohamed30 2017-05-31T09:50:23Z Make a diagonal, linear reference line for accumulated values https://community.qlik.com/t5/App-Development/Make-a-diagonal-linear-reference-line-for-accumulated-values/m-p/1364666#M30712 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>For each of the countries we deliver to, we have set total estimated sales (TES) for this year. Like this:</P><P></P><P>Country&nbsp;&nbsp;&nbsp;&nbsp; Total estimated sales in 2017</P><P>X&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12.000.000</P><P></P><P>We have a bar chart in which we show the accumulated monthly sales for this year. To show if the accumulated monthly sales meet the accumulated monthly ESTIMATED sales I would like to add a linear (diagonal) reference line which shows the accumulated estimed monthly sales ((TES/12)*month number).</P><P></P><P>I would like to this without adding a measure to my chart and just make use of the reference line function.</P><P></P><P>Any ideas to solve this are much appreciated!</P><P></P><P>Regards,</P><P></P><P>Hugo</P></BODY></HTML> Wed, 31 May 2017 09:34:48 GMT https://community.qlik.com/t5/App-Development/Make-a-diagonal-linear-reference-line-for-accumulated-values/m-p/1364666#M30712 2017-05-31T09:34:48Z Re: Make a diagonal, linear reference line for accumulated values https://community.qlik.com/t5/App-Development/Make-a-diagonal-linear-reference-line-for-accumulated-values/m-p/1364667#M30713 <HTML><HEAD></HEAD><BODY><P>On chart properties&gt;Presentation&gt;right bottom&gt;under reference lines you can add it</P></BODY></HTML> Wed, 31 May 2017 09:50:23 GMT https://community.qlik.com/t5/App-Development/Make-a-diagonal-linear-reference-line-for-accumulated-values/m-p/1364667#M30713 tajmohamed30 2017-05-31T09:50:23Z