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: 
Go-Anna
Contributor III
Contributor III

Linear trend line for accumulated values

I have used this formula:

linest_m(total aggr(if(sum([Hours Worked]),sum([Hours Worked])),Period),Period)*only({1}Period)+linest_b(total aggr(if(sum([Hours Worked]),sum([Hours Worked])),Period),Period)

If I accumulate both my "worked hours" measure and my linear measure above, then the line is no longer linear? How can I make it straight again?

Thanks,

Labels (2)
0 Replies