Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
Not applicable

Re: Linear trendline on a Scatterplot

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

jonbmorrison
New Contributor III

Re: Linear trendline on a Scatterplot

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.