Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator 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
Highlighted

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

Highlighted
Creator II
Creator II

Thanks for reply.

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

Highlighted
Creator II
Creator II

Y: Sum(kWh)

X: AVG(Temp)

Dimension is week.