5 Replies Latest reply: Mar 22, 2017 12:45 PM by Etienne M RSS

    Qlik sense charts-adding a trend line as a reference line

    Gus Feltham

      Please see attached chart - I would like to add a trend line similar to how the target line appears (i.e. without data points, but ideally red in colour and with a label) but I want to keep data points on my main measure.   The formula below provides the trend line okay as a measure, but when I use the same as a reference line it doesn't appear?

       

      linest_m(total aggr(if(avg(purple8mins),avg(purple8mins)),Mth),Mth)* 

      only({1}Mth)+linest_b(total aggr(if(avg(purple8mins),avg(purple8mins)),Mth),Mth)