11 Replies Latest reply: Mar 3, 2017 4:07 AM by Andrzej Topolewski Branched from an earlier discussion. RSS

    Re: How to add lineal trend in Qlik sense

      Hi Michael,

      Could you please help . I want to display trend line in my QlikSense app but for some reason when i try to use your code it doesn't work.

      Here is the code used:

      linest_m(total aggr(if(sum(SalesDollars),sum(SalesDollars)),Year_Month),Year_Month)* 

      only({1}Year_Month)+linest_b(total aggr(if(sum(SalesDollars),sum(SalesDollars)),Year_Month),Year_Month)



      Year_Month is in this format 2014-2

      I don't get any lines or point on my graph   when i try to use code above.

      Thank you in advance.