2 Replies Latest reply: Mar 8, 2017 6:12 PM by Mary Chen RSS

    Dates Sort differences in pivot tables

    Dafnis X

      Hi,

       

      Added a new thread here:

      https://community.qlik.com/message/1101460#1101460

       

       

       

      This is really an annoying issue and I can't figure the reason for the inconsistent behavior of dates sort in Excel reports

      which are created in NP.

       

      In the following example, I exported data directly from the source model (the connection) to Excel, and the the dates are sorted as expected:

      SORTEXCEL.png

      In the pivot  created the with NP, sometimes the dates are not sorted correctly:

      You can see that the source table below is sorted , but the pivot is not.

      SORTNP.png

      If I do "Text to column" on both source table, only the marked dates are formatted as dates:

      textto_column.png

      Anyone has an idea how should I resolve this?

       

      Thanks!

       

      Message was edited by: Dafnis X added a new thread