Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
DS14
Partner - Contributor III
Partner - Contributor III

Linear Regression chart in qliksense

Hi Experts,

I want to create a linear regression chart in qliksense, my dimension will be customer and measures are sales and contribution.

As I am new to qliksense can anyone please suggest how to create a linear regression chart by using scatter chart in qliksense.

Please help me

Thanks in advance!

Labels (3)
2 Replies
Keitaru
Creator II
Creator II

Look something like this

linest_m(y,x)*x+linest_b(y,x)
You may need to use a plugin to achieve your linear line in the scatter chart.

 

Reference:
https://community.qlik.com/t5/Qlik-Sense-Enterprise-Documents/Calculating-trend-lines-values-and-for...

DS14
Partner - Contributor III
Partner - Contributor III
Author

Hi Keitaru,

Thanks for the reference, Can we  form trendline without using aggr function in the expression.

* Is it possible to achieve this in scatter chart in Qliksense.