Discussion board where members can get started with Qlik Sense.
Good day Qlik Community!
Is there a way to draw a trend line in a scatter plot? I do believe it uses he formula y=mx+b but what is its equivalent in qlik sense? Can you also provide some sample data and how to do it?
Many thanks in advance!
Yes you can draw a trend line in a scatter plot. Unfortunately you can`t use the same easy way like in Qlikview. You need to create a reference line and use an expression which calculate the trendline (y=mx+b). linest_m & linest_b functions also work in qlik sense.
Please see following posts:
Thanks for the reply. I tried using the formula you gave but I never saw any reference line appearing in the scatter plot.
Could you help me out?
The y-expression should be Win Rate
The x-expression would be Distance in KM
To upload a sample, click on the "Use advanced editor option" at the top right of the reply edit box, and then click "Attach" at the bottom right of the advanced edit box.
Did you get the answer?
I have the similar case and would like to know the following:
1. Which reference line should we add: X-axis or Y-axis?
2. how to write the expression? Right now, I can only get a wrong straight line with LINEST_M([Win Rate], [Distance (KM)])
Can Ronny or anyone else help?