"Trendline Linear" Reference line 10% help

[Anonymous]

Hi,

What is the expression to create two linear trendlines +/- 10%?

X: AVG(Temp)

Y: Sum(kWh)

I want the chart to look like this:

[sunny_talwar]

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

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/ChartFunctions/Statistic...

[Anonymous]

Thanks for reply.

I have tried, but i dont understand how to use that function in my application...

[Anonymous]

Y: Sum(kWh)

X: AVG(Temp)

Dimension is week.