Qlik Community

Qlik Sense App Development

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

benwashburne
New Contributor III

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
Community Browser