0 Replies Latest reply: Sep 12, 2018 10:35 AM by AJ Qlik RSS

    How to add mulit average lines by quarter on the same chart

    AJ Qlik

      Hello Qlik users,

       

      I have created a chart by month and rate. The Dimension is month for 2 years, and expression is a rate.

      It is a line chart. I need add a average line of percent for each quarter and also a particular time range, before July and after July.

      data have:

      Month, Amount

      01/2015, 6.0

      02/2015,4.2

      03/2015,7.1

       

      ....

      12/2016, 4,3

       

       

      How can I add average line by time conditions on expression?

       

      Thanks,

       

      AJ