topic Sort by Date in Pivot Table Is not working in QlikView https://community.qlik.com/t5/QlikView/Sort-by-Date-in-Pivot-Table-Is-not-working/m-p/717403#M1070456 <HTML><HEAD></HEAD><BODY><P><BR />Hello!</P><P></P><P>I'm trying to sort&nbsp; in ascending by [Base Material] , then&nbsp; by PDD fields but for some reasons the PDD field failed to sort out.&nbsp; I tried checking&nbsp; the Text in sort tab and numeric value to no avail.&nbsp; I also tried using the expression date(PDD) but&nbsp; still doesnt sort right.</P><P></P><P>Pls help...</P><P></P><P>Tks.</P></BODY></HTML> Wed, 20 Aug 2014 20:39:41 GMT Anonymous 2014-08-20T20:39:41Z Sort by Date in Pivot Table Is not working https://community.qlik.com/t5/QlikView/Sort-by-Date-in-Pivot-Table-Is-not-working/m-p/717403#M1070456 <HTML><HEAD></HEAD><BODY><P><BR />Hello!</P><P></P><P>I'm trying to sort&nbsp; in ascending by [Base Material] , then&nbsp; by PDD fields but for some reasons the PDD field failed to sort out.&nbsp; I tried checking&nbsp; the Text in sort tab and numeric value to no avail.&nbsp; I also tried using the expression date(PDD) but&nbsp; still doesnt sort right.</P><P></P><P>Pls help...</P><P></P><P>Tks.</P></BODY></HTML> Wed, 20 Aug 2014 20:39:41 GMT https://community.qlik.com/t5/QlikView/Sort-by-Date-in-Pivot-Table-Is-not-working/m-p/717403#M1070456 Anonymous 2014-08-20T20:39:41Z Re: Sort by Date in Pivot Table Is not working https://community.qlik.com/t5/QlikView/Sort-by-Date-in-Pivot-Table-Is-not-working/m-p/717404#M1070457 <HTML><HEAD></HEAD><BODY><P>Try to put in the second field (Sales Order) your classification by Expression = PDD<IMG alt="Test2.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/64881_Test2.png" style="width: 620px; height: 349px;" /></P></BODY></HTML> Wed, 20 Aug 2014 21:27:12 GMT https://community.qlik.com/t5/QlikView/Sort-by-Date-in-Pivot-Table-Is-not-working/m-p/717404#M1070457 ecolomer 2014-08-20T21:27:12Z Re: Sort by Date in Pivot Table Is not working https://community.qlik.com/t5/QlikView/Sort-by-Date-in-Pivot-Table-Is-not-working/m-p/717405#M1070458 <HTML><HEAD></HEAD><BODY><P>Thank You, Enrique...It worked...I've been stuck on this for days...Just wondering why I have to place the =PDD in sales order field and not in the PDD field ?</P><P></P><P>Tks.</P></BODY></HTML> Wed, 20 Aug 2014 23:03:24 GMT https://community.qlik.com/t5/QlikView/Sort-by-Date-in-Pivot-Table-Is-not-working/m-p/717405#M1070458 Anonymous 2014-08-20T23:03:24Z