2 Replies Latest reply: May 24, 2017 11:22 PM by Gaston Tan RSS

    Line chart dimension name of month

    Gaston Tan

      Hi all,

       

      Just a minor issue that i can't seem to solve.

      I have a line chart with its x-axis with dates displayed according to the month name.

      I am using a drill-down chart, hence the following equations for the drill-down dimension are as follows:

      =Year(Date(Date#(MYDATE,'DDMMYYYY')))

      =Month(Date(Date#(MYDATE,'DDMMYYYY')))

      =Date(Date#(MYDATE,'DDMMYYYY'))

       

      Whenever i click the year to see the months, i will have August displayed as "Augk" instead of "Aug".

      Qlikk.png

       

      Any help is appreciated.

       

      Thanks and regards,

      Gaston