Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Linear trendline on a Scatterplot

Good Morning Qlikers,

Hope everyone is having a lovely day.

I am having a slight issue when adding a linear model using linest_m() and linest_b() to a scatter plot. As you can see from the scatter plot below I have calculated the gradient and y-intercept, but I am unable to add this is as a trend line.

Previous posts in the community have shown how to add a trend line to a bar chart by adding an extra measure ( How to add lineal trend in Qlik sense). However, as you cannot add extra measures to a scatter plot this method doesn't apply. So I attempted to add the trend line equation through Add-ons -> X-axis reference lines -> Add reference line. This still didn't work for me.

I have attached the data as a CSV file and also uploaded the QVF app.

Scatter plot of Material Property Vs Delta T

Scatterplot.PNG

Background to data, investigating whether there is any correlation between varying process time (delta t) on material property.

All help is greatly appreciated!

Thanks
Steve

2 Replies
Highlighted
Not applicable

Linear trend line on a scatter plot, is this not possible?

Highlighted
Contributor III
Contributor III

Steve

I've never gotten a good answer either - there are a few different threads out there - here is another one

Re: Diagonal reference line in scatter chart in Sense??

I'm reaching out again to the Qlik team to see where and when this is going to be added - its been in View for years.