3 Replies Latest reply: Feb 9, 2018 1:34 AM by P M RSS

    Display last 12 months data - qliksense

    Balaji SJ

      Hello People


      I want to display last 12 months sales data of different categories in a line chart. So i wrote the set analysis expression,


      Sum( {$<month1={">=$(=MonthStart(AddMonths(Max(month1),-12)))"}*{"<$(=MonthEnd(Max(month1)))"}>} sales)


      I get last 12 months data when i select month filter but the categories are not getting displayed.




      Please help me solve this issue.