3 Replies Latest reply: Jul 25, 2017 8:10 AM by Arvind Patil RSS

    Remove hyphen from barchart

    Mahendra Epuru

      Hi All,

       

           Here, am getting a hyphen(-) in the bar chart where it should display the name of current month i.e. july.

           I can't even apply the filter over there.

       

      qlikview.png

      load Scrpit:

       

      [PROBLEM_MANAGEMENT_OPENMONTH]:

      LOAD MonthName(YEAR_OPEN_DATE,IterNo()-1) as OpenMonth,

      PROBLEM_TICKET_OPENDATE,

      PROBLEM_TICKET

      Resident PROBLEM_MANAGEMENT_ACTIONS

      While MonthName(YEAR_OPEN_DATE,IterNo()-1) < MonthName(PROBLEM_TICKET_CLOSEDATE) ;

       

       

      The expression am using is :

      count({< PROBLEM_TICKET_OPENDATE={'>$(=AddMonths(Max(PROBLEM_TICKET_OPENDATE),-60))'}>} DISTINCT PROBLEM_TICKET)