Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Linear Trend Line (QS) despite of date gaps

Hi all,

I am trying to add a trend line based on linear regression to my chart (have tried using both a line graph and a combo chart).

My dimension is a date field, but there are gaps, as I don't have data on all dates.

I have tried inserting a trend line using:

linest_m(total aggr(Y,X), X)*X + linest_b(total aggr(Y,X),X)

This, however, leaves me with a "broken" trend line because of the gaps in my dates.

I have tried to change my dimension into consecutive numbers using =aggr(rank(-DATEFIELD),DATEFIELD)-1

Changing the dimension works fine itself, but unfortunately it doesn't help me creating my trend line. I have also tried replacing my datefield in my expression with the above aggr-expression.

Any help would be appreciated.

1 Reply
Anonymous
Not applicable
Author

I still haven't found a solution to this, so any help would (still) be appreciated