5 Replies Latest reply: Apr 5, 2016 2:20 AM by Chetann Sehgal RSS

    unable to calculate previous Month sales in Qlik Sense

    Chetann Sehgal



      I am trying to use below formula in Qlik Sense which works fine in QlikView but not in Qlik Sense.


      Sum({<Month_Num={"$(=Max(Month_Num)-1)"}>}[Sales Amount (Actual)])


      It gives zero only. in Qlik Sense.


      Any help will be appreciated.