topic Re: Is it possible to sort a pivot table in a particular order? in QlikView https://community.qlik.com/t5/QlikView/Is-it-possible-to-sort-a-pivot-table-in-a-particular-order/m-p/967974#M331639 <HTML><HEAD></HEAD><BODY><P>In the sort tab, try by expression:</P><P></P><P>Match(YourField, 'Wages &amp; Salaries', 'General &amp; Admin' , ....)</P></BODY></HTML> Wed, 30 Sep 2015 10:42:47 GMT tresB 2015-09-30T10:42:47Z Is it possible to sort a pivot table in a particular order? https://community.qlik.com/t5/QlikView/Is-it-possible-to-sort-a-pivot-table-in-a-particular-order/m-p/967973#M331638 <HTML><HEAD></HEAD><BODY><P>Is it possible to sort a pivot table in a particular order ignoring values?</P><P></P><P>EG:</P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 285px;"><TBODY><TR><TD class="xl64" height="21" width="285">Wages &amp; Salaries</TD></TR><TR><TD class="xl64" height="20">General &amp; Admin</TD></TR><TR><TD class="xl64" height="20">Rent, rates &amp; service chg</TD></TR><TR><TD class="xl64" height="20">Professional Non-Exec Directors</TD></TR><TR><TD class="xl64" height="20">Professional consultancy</TD></TR><TR><TD class="xl64" height="20">IT </TD></TR><TR><TD class="xl64" height="20">Finance </TD></TR><TR><TD class="xl64" height="20">Legal</TD></TR><TR><TD class="xl64" height="20">Insurance</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 30 Sep 2015 10:37:20 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-sort-a-pivot-table-in-a-particular-order/m-p/967973#M331638 anthony_kinsell 2015-09-30T10:37:20Z Re: Is it possible to sort a pivot table in a particular order? https://community.qlik.com/t5/QlikView/Is-it-possible-to-sort-a-pivot-table-in-a-particular-order/m-p/967974#M331639 <HTML><HEAD></HEAD><BODY><P>In the sort tab, try by expression:</P><P></P><P>Match(YourField, 'Wages &amp; Salaries', 'General &amp; Admin' , ....)</P></BODY></HTML> Wed, 30 Sep 2015 10:42:47 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-sort-a-pivot-table-in-a-particular-order/m-p/967974#M331639 tresB 2015-09-30T10:42:47Z Re: Is it possible to sort a pivot table in a particular order? https://community.qlik.com/t5/QlikView/Is-it-possible-to-sort-a-pivot-table-in-a-particular-order/m-p/967975#M331640 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>By default QV will not recognize which order you would like to sort it out... if you have any custom order in your mind, tell to QV that you are going to sort out with your custom order and provide ranks to the values and then go for ascending or descending..</P><P></P><P>HTH</P><P>Sreeni</P></BODY></HTML> Wed, 30 Sep 2015 10:43:59 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-sort-a-pivot-table-in-a-particular-order/m-p/967975#M331640 SreeniJD 2015-09-30T10:43:59Z Re: Is it possible to sort a pivot table in a particular order? https://community.qlik.com/t5/QlikView/Is-it-possible-to-sort-a-pivot-table-in-a-particular-order/m-p/967976#M331641 <HTML><HEAD></HEAD><BODY><P>Cheers</P></BODY></HTML> Wed, 30 Sep 2015 10:52:12 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-sort-a-pivot-table-in-a-particular-order/m-p/967976#M331641 anthony_kinsell 2015-09-30T10:52:12Z