4 Replies Latest reply: Mar 7, 2018 1:57 AM by Balaji SJ RSS

    Previous month using set analysis in qliksense

    Balaji SJ

      Hello people

       

      I have created date field using this expression,

      Date( MakeDate( left(acc_period,4) , right(acc_period,2) ) , 'YYYY-MM' )

       

      I have a requirement to display previous month sales based on the selected Date. I used the below exp for previous month sales,

      =Sum({$<Date={"$(=Max(Date)-1)"}>}sales)

       

      But it is not working. Please help me to solve this issue.

       

      Date format - YYYY-MM (2018-12)