linest_m() and aggr() Calculation problem

Tue, 14 May 2013 08:26:41 GMT

Hello! I have problem with the following expression of linest_m() and aggr():

LINEST_M

(
total aggr(

          RangeSum(
         above(
             sum(if(TYPE=TYPE_01 ,1,0))

          ,0, RowNo())
          )
     ,DT_TIME_05)

,DT_TIME_05

)

The aggr() cumulates the result of sum() with DT_TIME_05. Actullay, this does return a result but the result is not correct, which means it does not correspond the regression line drawn by:

RangeSum(
above(
sum(if(TYPE=TYPE_01 ,1,0))

,0, RowNo())
)

I think the problem might be that aggr() returns a group of datas that are not in order of DT_TIME_05.

Does anyone have any idea about this problem? Thank you so much for your response!!!

topic linest_m() and aggr() Calculation problem in QlikView

linest_m() and aggr() Calculation problem