16 Replies Latest reply: Oct 26, 2017 3:24 AM by S Satti RSS

    Error in expression

    Nikhil Garg

      Hey,

      In qliksense, i am trying to create a variable by calculate Year of posting date

      My Date format is : MM/DD/YYYY hh:mm:ss TT

       

      I am trying like:

      vCurYear = Year(Date(Today(1), 'MM/DD/YYYY'))

      Let say date is 10/25/2017, above expression giving me 2.02K in qliksense.

      I want to store value i.e. 2017 in variable i.e. vCurYear.

      How to solve this?

       

      Thanks,

      Nikhil Garg