This content has been marked as final. Show 3 replies
I've explored many potential answers to this question. Many end up pointing to this answer How to add lineal trend in Qlik sense but it doesn't seem to work for a reference line in a scatter plot.
The attached qvf has the chart (Chart 1) from the above question and Chart 2 which is a scatter plot. Below that chart I have KPIs representing the variables for Chart 1 such as the slope and y-intercept.
I'd like to create a best fit line for Chart 2. I'm thinking the code might look like:
This mimics Chart 1 and is essentially y=mx+b.
My question is: how do you create a best fit line using y=mx+b (or anything) on a scatter plot chart in Qlik Sense?
Thanks so much for any ideas and suggestions and hopefully answers.