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,



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


      Date format - YYYY-MM (2018-12)