X axis problem when using Linest_M function

AGGR & LINEST_M function


Thank you to https://community.qlikview.com/thread/115111

SOLVED by using : aggr( rowno(), yearmonth))

The trendline formula uses the index number of the x-axis dimension values, i.e the left most value is 1, the next 2 etc. The linest_m function uses the actual x-axis dimension values. You could try:

linest_m(aggr( sum(....vSold...)/sum(....Quantita...) , yearmonth), aggr( rowno(), yearmonth))

See attached example.