topic Re: pivot table sort issues in QlikView https://community.qlik.com/t5/QlikView/pivot-table-sort-issues/m-p/1392258#M820162 <HTML><HEAD></HEAD><BODY><P>I doubt you can use something like </P><P></P><P>Aggr(Max(OpenDays), Max(LoadDate), ....)</P><P>May be try like:</P><P></P><P><SPAN style="font-size: 13.3333px;">= Aggr(Max({&lt;LoadDate = {"$(= Date(Max(LoadDate)))"} &gt;} OpenDays), Max(LoadDate), EMP_Name...)</SPAN></P></BODY></HTML> Sat, 12 Aug 2017 01:34:12 GMT vishsaggi 2017-08-12T01:34:12Z pivot table sort issues https://community.qlik.com/t5/QlikView/pivot-table-sort-issues/m-p/1392257#M820161 <HTML><HEAD></HEAD><BODY><P>I have a pivot table with 5 dimensions and 4 expressions.</P><P></P><P>one of the expressions are max(Days Open]). I want to sort by that only based on the last date (8/8/2017) but it does not seem to be working.</P><P></P><P>I tried to use aggr(max([days open], max(loadDate)) in all the dimensions .</P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Can you please help?</SPAN></P><P></P><P>thanks!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/pivot-table-sort-issues/m-p/1392257#M820161 alexpanjhc 2020-11-25T16:16:04Z Re: pivot table sort issues https://community.qlik.com/t5/QlikView/pivot-table-sort-issues/m-p/1392258#M820162 <HTML><HEAD></HEAD><BODY><P>I doubt you can use something like </P><P></P><P>Aggr(Max(OpenDays), Max(LoadDate), ....)</P><P>May be try like:</P><P></P><P><SPAN style="font-size: 13.3333px;">= Aggr(Max({&lt;LoadDate = {"$(= Date(Max(LoadDate)))"} &gt;} OpenDays), Max(LoadDate), EMP_Name...)</SPAN></P></BODY></HTML> Sat, 12 Aug 2017 01:34:12 GMT https://community.qlik.com/t5/QlikView/pivot-table-sort-issues/m-p/1392258#M820162 vishsaggi 2017-08-12T01:34:12Z Re: pivot table sort issues https://community.qlik.com/t5/QlikView/pivot-table-sort-issues/m-p/1392259#M820163 <HTML><HEAD></HEAD><BODY><P>Thanks for your reply, Vishwarath, but it is still not sorting it correctly.</P></BODY></HTML> Mon, 14 Aug 2017 12:47:17 GMT https://community.qlik.com/t5/QlikView/pivot-table-sort-issues/m-p/1392259#M820163 alexpanjhc 2017-08-14T12:47:17Z Re: pivot table sort issues https://community.qlik.com/t5/QlikView/pivot-table-sort-issues/m-p/1392260#M820164 <HTML><HEAD></HEAD><BODY><P>Is it possible to share some sample data to look into?</P></BODY></HTML> Mon, 14 Aug 2017 14:19:27 GMT https://community.qlik.com/t5/QlikView/pivot-table-sort-issues/m-p/1392260#M820164 vishsaggi 2017-08-14T14:19:27Z