1 Reply Latest reply: Nov 4, 2015 3:52 PM by Stefan Wühl RSS

    Display slope of a trendline in straight table

    Brad Guillot

      I'd like to display the slope of a trend line in a straight table. The trend line is showing the trend for variable costs for attending physicians on a cost per case basis. below is what I am currently using that is not working. I've tried several times to get the linest_m function to work and I'm having some trouble even getting a value to show. Any help at all would be greatly appreciated.

       

      I am new to qlikview and the information I've gathered to put this together was pulled from a few different places. Feedback is welcomed.

       

      =aggr(linest_m(aggr(sum(VariableDirectCostAMT),AttendingProviderNM,YearMonthNM),AttendingProviderNM),YearMonthNM)