topic Pivot table sorting problem in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-sorting-problem/m-p/835070#M293764 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a pivot table with 4 Dimensions and 6 expressions.</P><P>I am applying sorting on basis of Expressions but for "others" as value, it is not getting sorted. For ex: my pivot chart due to Others value is looking like:</P><P></P><P>Dim1&nbsp; Dim2&nbsp;&nbsp; Exp1&nbsp; </P><P>A1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Val1&nbsp;&nbsp;&nbsp;&nbsp; 500</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Val2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 478</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Others&nbsp;&nbsp; 93</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Val3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 450</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Val4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</P><P></P><P></P><P>Due to this Others as value my sorting gets disrturbed. What can i do for this?</P><P></P><P>thanks</P></BODY></HTML> Fri, 05 Jun 2015 08:58:55 GMT nikhilgarg 2015-06-05T08:58:55Z Pivot table sorting problem https://community.qlik.com/t5/QlikView/Pivot-table-sorting-problem/m-p/835070#M293764 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a pivot table with 4 Dimensions and 6 expressions.</P><P>I am applying sorting on basis of Expressions but for "others" as value, it is not getting sorted. For ex: my pivot chart due to Others value is looking like:</P><P></P><P>Dim1&nbsp; Dim2&nbsp;&nbsp; Exp1&nbsp; </P><P>A1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Val1&nbsp;&nbsp;&nbsp;&nbsp; 500</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Val2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 478</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Others&nbsp;&nbsp; 93</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Val3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 450</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Val4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</P><P></P><P></P><P>Due to this Others as value my sorting gets disrturbed. What can i do for this?</P><P></P><P>thanks</P></BODY></HTML> Fri, 05 Jun 2015 08:58:55 GMT https://community.qlik.com/t5/QlikView/Pivot-table-sorting-problem/m-p/835070#M293764 nikhilgarg 2015-06-05T08:58:55Z Re: Pivot table sorting problem https://community.qlik.com/t5/QlikView/Pivot-table-sorting-problem/m-p/835071#M293765 <HTML><HEAD></HEAD><BODY><P>Can you post the sample application?</P></BODY></HTML> Fri, 05 Jun 2015 09:10:10 GMT https://community.qlik.com/t5/QlikView/Pivot-table-sorting-problem/m-p/835071#M293765 Kushal_Chawda 2015-06-05T09:10:10Z