Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
benwashburne
Partner - Creator
Partner - Creator

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
0 Replies