3 Replies Latest reply: Oct 11, 2018 12:27 PM by Croix Christenson RSS

    6 Month Trend Line Chart Help

    Ale Kong

      Hi all,

       

      I am using Qlik Sense and trying to create a 6 month dynamic line chart.

       

      Right now my dimension is:


      =date#(Month_Sort)

      Month_Sort displays the date as 'YYYY-MMM'.

       

      My measure is:

       

      count({1<Date={'>=$(=AddMonths(Max(Date),-5)) <=$(=(Max(Date)))'}>}[Review Due Date])

       

      The line chart shows all the data and not the most recent 6 months.

       

      Can anyone help me with my issues?

       

      Thanks,

      Ale