4 Replies Latest reply: Feb 16, 2016 4:46 AM by Sunny Talwar RSS

    Last Month According to Data

    Hirish V

      Dear Qlikers,

       

      According to the below data,

      Data latest month.PNG

       

      I need to acquire the latest Month Sales means which is not '0',

       

      I tried Expression like this,

      =Sum({<MonthNum={'$(=Max(MonthNum))'},[Entry Type]={'Sales'}>}Value)

       

      But its not working!!

       

      It should be like this,

       

      =Sum({<MonthNum={'6'},[Entry Type]={'Sales'}>}Value) like this,

       

      Thanks in advance,

      PFA,

      Hirish