Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
livio218526
Contributor

Linear Regression like Reference Line (Scatter-Plot)

Hi everyone,

I need to add a linear regression to a scatter plot like a reference line.

Here an example:

Capture.JPG

How I can to do it?

Thanks,

Livio

4 Replies
ChennaiahNallani
Contributor III

Re: Linear Regression like Reference Line (Scatter-Plot)

livio218526
Contributor

Re: Linear Regression like Reference Line (Scatter-Plot)

Sorry, but I don't understand.

I need to add a linear regression about "Delta AVG Process Time".

I attached a simple of Application with the scatter plot where i want to have a reference line.

balabhaskarqlik
Honored Contributor

Re: Linear Regression like Reference Line (Scatter-Plot)

In your scatter plot, add an extra measure as:

linest_m(total aggr(if(sum(DeltaAVG#Rows),sum(DeltaAVG#Rows)),DeltaAVGProcessTime),DeltaAVGProcessTime) * 

only({1}DeltaAVGProcessTime) +

linest_b(total aggr(if(sum(DeltaAVG#Rows),sum(DeltaAVG#Rows)),DeltaAVGProcessTime),DeltaAVGProcessTime).

livio218526
Contributor

Re: Linear Regression like Reference Line (Scatter-Plot)

not work