0 Replies Latest reply: Jul 28, 2016 4:29 PM by Archana handu RSS

    help setting default date for qliksense app

    Archana handu

      I have a field as MonthYear which have values as " JAN-2016 , Feb-2016 , and so on."

      i am trying to show my trend line chart for last 12mths only.


      i am creating a variable as



      but its not working

      if(gertselectedcount(MonthYear)=0, MonthYear= addmonths(date(MonthYear),'MM-DD-YYYY')-12),max(MonthYear)), but its not working .



      ANy suggestions or help is highly appreciated.


      The said filed was created in script by concatenating Month & Year