topic Re: &quot;Trendline Linear&quot; Reference line 10% help in QlikView https://community.qlik.com/t5/QlikView/quot-Trendline-Linear-quot-Reference-line-10-help/m-p/78840#M511544 <HTML><HEAD></HEAD><BODY><P>May be use Linest function to create a linear line and multiple it with 1.10 and 0.90 to get the two other lines</P><P><A href="https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/ChartFunctions/StatisticalAggregationFunctionsinCharts/linest-example.htm" title="https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/ChartFunctions/StatisticalAggregationFunctionsinCharts/linest-example.htm">https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/ChartFunctions/StatisticalAggregationFunctionsinCharts/linest-example.htm</A></P></BODY></HTML> Mon, 23 Apr 2018 13:37:25 GMT sunny_talwar 2018-04-23T13:37:25Z "Trendline Linear" Reference line 10% help https://community.qlik.com/t5/QlikView/quot-Trendline-Linear-quot-Reference-line-10-help/m-p/78839#M511543 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>What is the expression to create two linear trendlines +/- 10%? </P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/200534_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>X: AVG(Temp)</P><P>Y: Sum(kWh)</P><P></P><P>I want the chart to look like this:</P><P><IMG alt="" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/200535_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Mon, 23 Apr 2018 13:29:18 GMT https://community.qlik.com/t5/QlikView/quot-Trendline-Linear-quot-Reference-line-10-help/m-p/78839#M511543 Anonymous 2018-04-23T13:29:18Z Re: "Trendline Linear" Reference line 10% help https://community.qlik.com/t5/QlikView/quot-Trendline-Linear-quot-Reference-line-10-help/m-p/78840#M511544 <HTML><HEAD></HEAD><BODY><P>May be use Linest function to create a linear line and multiple it with 1.10 and 0.90 to get the two other lines</P><P><A href="https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/ChartFunctions/StatisticalAggregationFunctionsinCharts/linest-example.htm" title="https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/ChartFunctions/StatisticalAggregationFunctionsinCharts/linest-example.htm">https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/ChartFunctions/StatisticalAggregationFunctionsinCharts/linest-example.htm</A></P></BODY></HTML> Mon, 23 Apr 2018 13:37:25 GMT https://community.qlik.com/t5/QlikView/quot-Trendline-Linear-quot-Reference-line-10-help/m-p/78840#M511544 sunny_talwar 2018-04-23T13:37:25Z Re: "Trendline Linear" Reference line 10% help https://community.qlik.com/t5/QlikView/quot-Trendline-Linear-quot-Reference-line-10-help/m-p/78841#M511545 <HTML><HEAD></HEAD><BODY><P>Thanks for reply.</P><P></P><P>I have tried, but i dont understand how to use that function in my application...</P></BODY></HTML> Mon, 23 Apr 2018 13:51:49 GMT https://community.qlik.com/t5/QlikView/quot-Trendline-Linear-quot-Reference-line-10-help/m-p/78841#M511545 Anonymous 2018-04-23T13:51:49Z Re: "Trendline Linear" Reference line 10% help https://community.qlik.com/t5/QlikView/quot-Trendline-Linear-quot-Reference-line-10-help/m-p/78842#M511546 <HTML><HEAD></HEAD><BODY><P>Y: Sum(kWh)</P><P>X: AVG(Temp)</P><P></P><P>Dimension is week. </P></BODY></HTML> Mon, 23 Apr 2018 13:52:24 GMT https://community.qlik.com/t5/QlikView/quot-Trendline-Linear-quot-Reference-line-10-help/m-p/78842#M511546 Anonymous 2018-04-23T13:52:24Z