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