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: 
Lorena_Rogaciano
Contributor
Contributor

Linear Trend

Good Morning. How to create a trend line in the scatter plot?

Labels (1)
6 Replies
petter
Partner - Champion III
Partner - Champion III

Lorena_Rogaciano
Contributor
Contributor
Author

Good Morning. I looked at the topic but it does not plot linear regression line on scatter plot. I would need something like the attached image. Anyway, asked in the topic indicated.

petter
Partner - Champion III
Partner - Champion III

Is it QlikView or Qlik Sense you want to do it with?

Lorena_Rogaciano
Contributor
Contributor
Author

Qlik sense. It looks like qlik view has this option, but no qlik sense. I just do not know what formula I could build it or where to insert it.

lironbaram
Partner - Master III
Partner - Master III

hi 

qlik sense native scatter chart only have axis referance lines , which mean straight line 

your easiest way to have trend line 

will be using Vizlib scatter chart which have trend lines option built in 

you should note they offer free version for up  to 5 users for testing 

but their extensions aren't free for production use

Lorena_Rogaciano
Contributor
Contributor
Author

I saw in other posts people who managed to trace the function with the linest_B and linest_M function, but I could not understand where they entered that equation to draw the line.