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.

       

      saa.png

       

      Please help me solve this issue.