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

    Expression for YTD sales in Qlik sense

    Chandrasheker Gompa



      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..