Qlik Community

Insight Advisor

Discussions about Insight Advisor in Qlik Sense®

IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

LINEST_R2 Straight Table


I am trying to find the R2 values for each customer in form of straight table. I am using this expression currently

=LINEST_R2(TOTAL AGGR(SUM(Amount),Month),Month)

to get R2 value for each customer where the x-axis is total amount and y-axis is Month.


However the straight table  shows the same R2 for all customers.


How can I calculate R2 values for each customers?

0 Replies