Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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

Simple diagonal trend line

Hi,

I am trying to create a simple diagonal trend line as an expression based off a slope formula. I have see plenty of discussion threads about using the linest_m function but none of them explain how to add a 'hard' reference line. All I have is a date field and a target field (the target number of orders) and I would like the line to be plotted based off it's slope.

Any and all help is greatly appreciated!

-Ben

  

Target ID (Late)
0.55
17.53
33.97
50.96
67.95
83.29
100.27
116.71
133.70
150.14
167.12
184.11

Date
43023
43054
43084
43115
43146
43174
43205
43235
43266
43296
43327
43358