2 Replies Latest reply: Apr 10, 2017 1:55 AM by Shamit Shah RSS

    Expression to get the latest month' sales

    Shamit Shah

      I have the following expression in QlikView which gives me the right result, but in Qlik Sense it shows a cumulative figure:

       

      =SUM({$<FYKPIFiscalYear = {$(=Max(FYKPIFiscalYear))}, FYKPIMonth= , FYKPIMonthYear={'>=$(vMaxBYM)'}>}Sales)

       

      Any idea what the correct expression should be in Qlik Sense?

       

      Thanks