topic Sort Order for Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Sort-Order-for-Pivot-Table/m-p/1015747#M344256 <HTML><HEAD></HEAD><BODY><P>Hi Every one</P><P></P><P>Yesterday I was looking an application that I worked about a couple of years ago, finding an error in a pivot table ordering.&nbsp; See in the file attached.</P><P></P><P>I already solve the problem making a week ordering field, but I interested to know how make an expression that sort correctly the table.</P><P></P><P>By any chance another solution I find is ordering the week by frequency, as the last week of a year, that is the beginning week of the next is cut off by the end, it always have less day than the other, so it works.</P></BODY></HTML> Fri, 29 Jan 2016 15:59:01 GMT jolivares 2016-01-29T15:59:01Z Sort Order for Pivot Table https://community.qlik.com/t5/QlikView/Sort-Order-for-Pivot-Table/m-p/1015747#M344256 <HTML><HEAD></HEAD><BODY><P>Hi Every one</P><P></P><P>Yesterday I was looking an application that I worked about a couple of years ago, finding an error in a pivot table ordering.&nbsp; See in the file attached.</P><P></P><P>I already solve the problem making a week ordering field, but I interested to know how make an expression that sort correctly the table.</P><P></P><P>By any chance another solution I find is ordering the week by frequency, as the last week of a year, that is the beginning week of the next is cut off by the end, it always have less day than the other, so it works.</P></BODY></HTML> Fri, 29 Jan 2016 15:59:01 GMT https://community.qlik.com/t5/QlikView/Sort-Order-for-Pivot-Table/m-p/1015747#M344256 jolivares 2016-01-29T15:59:01Z Re: Sort Order for Pivot Table https://community.qlik.com/t5/QlikView/Sort-Order-for-Pivot-Table/m-p/1015748#M344257 <HTML><HEAD></HEAD><BODY><P>Maybe use a sort expression</P><P></P><P>=Min(Sa_Date)</P></BODY></HTML> Fri, 29 Jan 2016 16:01:05 GMT https://community.qlik.com/t5/QlikView/Sort-Order-for-Pivot-Table/m-p/1015748#M344257 swuehl 2016-01-29T16:01:05Z