4 Replies Latest reply: Dec 16, 2013 11:53 AM by Zebediah Black RSS

    Graphing Previous 6 Months

      Afternoon,

       

      I have a simple table with amount and recorddate fields. I've created a Month field (MonthStart) and Year field from the recorddate column. I am trying to graph the previous 6 months using the below set analysis. I searched the QlikView Community and found this expression.

       

      Sum({Month={>=$(=max(Month)-6 <=$(=max(Month)'}>} amount

       

      Using that set analysis I get all months <= the selection I make instead of just the previous 6. Any ideas on how to correct this?