Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
marius_larsen
Contributor II

"Trendline Linear" Reference line 10% help

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:

3 Replies

Re: "Trendline Linear" Reference line 10% help

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...

marius_larsen
Contributor II

Re: "Trendline Linear" Reference line 10% help

Thanks for reply.

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

marius_larsen
Contributor II

Re: "Trendline Linear" Reference line 10% help

Y: Sum(kWh)

X: AVG(Temp)

Dimension is week.