Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

linest_m() and aggr() Calculation problem

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!!!

0 Replies