18 Replies Latest reply: Oct 29, 2017 12:27 AM by Nikhil Garg RSS

    Error in Expression

    Nikhil Garg

      Hello All,

      I am stuck in one issue in QLIKSENSE.

      I have created a variable vCurMonth = "=Month(Today())"

       

      I am calculating Sum(Amount) as:

      Sum({<Year = {'$(vCurYear)'},Month = {'<=$(vCurMonth)'},[Transaction Type] = {'Sales'}>}Amount)

      Above expression is not working because of following clause:

      Month = {'<=$(vCurMonth)'}


      Can anyone help me in this?