19 Replies Latest reply: Dec 27, 2017 10:10 AM by Sunny Talwar RSS

    Linest_b, linest_m, tables and multiplications

    Simone Trabattoni

      Hi community,

      a very fast question. I'm using the nice Linest_b function.

      https://help.qlik.com/en-US/sense-cloud/Subsystems/CloudHub/Content/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm

       

      My dataset is something like:

      load*inline

      [a,x,y

      a,3,4

      b,4,5

      c,5,9

      d,7,1

      ];

       

      So I need to have a table with this simple result

      axyy*beta
      a

      3

      4(x)-linest_b(x,y)-LINEST_M(x,y)*(y)
      b45(x)-linest_b(x,y)-LINEST_M(x,y)*(y)
      c59(x)-linest_b(x,y)-LINEST_M(x,y)*(y)
      d71(x)-linest_b(x,y)-LINEST_M(x,y)*(y)

       

      But I cannot manage to have a result, everything goes grey. I've tried also to do something like

       

      (x)-num(linest_b(x,y))-num(LINEST_M(x,y))*(y)

       

      or

       

      sum(x)-num(linest_b(x,y))-num(LINEST_M(x,y))*sum(y)

       

      But nothing happened but to have an useless total.

      Could I ask you an help?

       

      Thanks in advance

      EDIT:

      Due further developements, it is, I'm using the model with y,x , not x,y. The reasoning are the same.