Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Trend/Regression Line in a Scatter Chart

I've read through a lot of similar posts on here but can't find a good answer on how to plot a linear trend line in a scatter chart.  E.g. with X as Sum(Sales) and Y as Count(Customer) and Store as the dimension.  

I've used the linest_m and linest_b functions to create a linear trend in a bar/line chart but when it comes to a scatter i can't get it to work.  For the Linest_m function I can add the Y values by creating an aggr() table but it doesn't seem to like it if I try the same for the X values.  

Has anyone had any success with this (using the reference lines)?

@Michael_Tarallo - I've read your posts on using the linest functions in bar and line charts and they make sense.  Any thoughts on how to use them in a scatter where X and Y are both aggregates?

3 Replies
Highlighted
Specialist III
Specialist III

Hi there,

 

Maybe you could try using a Combo Box type chart instead. I guess the result you need will be the same as a Scatter Chart. Try your approach with a Combo Box.

 

Best regards,

MB

Highlighted
Partner
Partner

Hi MB,

The problem with a combo chart is that the only dimension is the X axis.  No option to split points/markers out by another dimension like you can in a scatter.

I get where you're coming from in that in a combo chart I could use, for example, aggr(count(customers),store) to create the equivalent x axis of count(customers) in a scatter chart.  The problem still remains of not being able to split out the markers though.  

Highlighted
Contributor III
Contributor III

@catalystmichael I also want to know when we will be able to do Regression lines on Scattor plot. It is quite an important feature to have. 

@Micheal Tarallo  The integration with R is not friendly and I cant get it to work. Do you guys have...