topic linest_m in a pivot table in QlikView https://community.qlik.com/t5/QlikView/linest-m-in-a-pivot-table/m-p/172083#M41765 <HTML><HEAD></HEAD><BODY><P>Has anyone been able to implement linest_m function in a pivot table with set analysis? I am looking for a couple of pointers.</P><P>I have a Fact table which has many different facts concat'd together. I want to find the slope on only 1 type of fact say, Sales Dollars/Sales Units for the last 6 months.</P><P>I was trying to do the trend line in a pivot but that's not possible so the slope is the next best thing to it.</P></BODY></HTML> Tue, 01 Jun 2010 12:57:01 GMT avastani 2010-06-01T12:57:01Z linest_m in a pivot table https://community.qlik.com/t5/QlikView/linest-m-in-a-pivot-table/m-p/172083#M41765 <HTML><HEAD></HEAD><BODY><P>Has anyone been able to implement linest_m function in a pivot table with set analysis? I am looking for a couple of pointers.</P><P>I have a Fact table which has many different facts concat'd together. I want to find the slope on only 1 type of fact say, Sales Dollars/Sales Units for the last 6 months.</P><P>I was trying to do the trend line in a pivot but that's not possible so the slope is the next best thing to it.</P></BODY></HTML> Tue, 01 Jun 2010 12:57:01 GMT https://community.qlik.com/t5/QlikView/linest-m-in-a-pivot-table/m-p/172083#M41765 avastani 2010-06-01T12:57:01Z