2 Replies Latest reply: Aug 30, 2018 2:39 AM by Michele De Nardi RSS

    QlikSense null trend line

    Michele De Nardi

      Good Afternoon,

      i'm trying to add a trend line to my combo chart by usign the formula mentioned in How to add lineal trend in Qlik sense thread.


      The base formula is this:


      linest_m(total aggr(if(sum(Sales),sum(Sales)),OrderDate),OrderDate)*  
      only({1}OrderDate)+linest_b(total aggr(if(sum(Sales),sum(Sales)),OrderDate),OrderDate) 


      so i replace with my measure and dimension to obtain the trend line.


      linest_m(total aggr(if(sum(Orders),sum(Orders)),Period),Period)*  
      only({1}Period)+linest_b(total aggr(if(sum(Orders),sum(Orders)),Period),Period)


      But i don't know why it returns null()...


      Can anybody help me ? I've attached the example qvf.

      2018-08-29 15_33_09-Qlik Sense Desktop.png