2 Replies Latest reply: May 18, 2016 9:04 AM by Chandrasheker Gompa RSS

    Expression for YTD sales in Qlik sense

    Chandrasheker Gompa

      Hi,

       

      Can somebody help me with a set analysis expression for YTD sales in Qlik Sense.. If I select month march it should be sum of Jan, Feb and March.

       

      I am using this expression  =sum({$ < Version = {"Actual 2016"},Month = {">= {'1'} <=$(=max(Month))"}>}SumOfBudget_Amount)

       

      if I am not selecting anything it is giving YTD .. if I am selecting March it is giving only March month amount not the accumulated ones..

       

      Can somebody advise please.. This is for a qlik sense app..

       

      Thanks

      Chandra