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:


      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?