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

      Hi,

       

      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.

       

      Thanks,

      Chetan