4 Replies Latest reply: Aug 30, 2016 6:56 AM by Marco Vicariucci RSS

    Sorting by Date

    Marco Vicariucci

      Hi,

       

       

      I need an help for a sorting problem.
      The records is composed by lots of timestamp in the format 'DD/MM/YYYY hh:mm:ss[.fff]' called DataAggiornamentoOp.
      I want to create a linechart with this dimension

      day(timestamp(DataAggiornamentoOp)) &'-'& month(timestamp(DataAggiornamentoOp))&'-'& year(timestamp(DataAggiornamentoOp))

      but I can't order the x-axis with the date, because of qlik understand this dimension like a "Text Field".

      I can I solve this problem?