Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
I think you can do it like demonstrated here:
Matching linest_m and linest_b function to auto-generated trendline
If you still have problems, please post a small sample QVW.