topic Re: sorting the dimension in pivot table in QlikView https://community.qlik.com/t5/QlikView/sorting-the-dimension-in-pivot-table/m-p/621352#M1115999 <HTML><HEAD></HEAD><BODY><P>Thank you for response</P></BODY></HTML> Fri, 07 Feb 2014 14:50:16 GMT 2014-02-07T14:50:16Z sorting the dimension in pivot table https://community.qlik.com/t5/QlikView/sorting-the-dimension-in-pivot-table/m-p/621348#M1115995 <HTML><HEAD></HEAD><BODY><P>Take a look at my pivot table below (example only).</P><P></P><P>Job is one of my dimensions and it diplays its contents as indicated below (Type3, Type 2 etc.).&nbsp; How can make Type3, Type2 display in ascending order. Example: <SPAN style="color: #ff0000;"><STRONG>Type1, Type2, Type3, Type4</STRONG></SPAN></P><P></P><P></P><P><STRONG>&nbsp;&nbsp;&nbsp; Testname&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Job&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </STRONG> <SPAN style="color: #ff0000;"><STRONG>Type3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Type2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Type4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Type1</STRONG></SPAN></P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6</P></BODY></HTML> Fri, 07 Feb 2014 14:42:45 GMT https://community.qlik.com/t5/QlikView/sorting-the-dimension-in-pivot-table/m-p/621348#M1115995 2014-02-07T14:42:45Z Re: sorting the dimension in pivot table https://community.qlik.com/t5/QlikView/sorting-the-dimension-in-pivot-table/m-p/621349#M1115996 <HTML><HEAD></HEAD><BODY><P>On Sort tab, you should be able to choose the dimension and do a sort by text.</P></BODY></HTML> Fri, 07 Feb 2014 14:45:59 GMT https://community.qlik.com/t5/QlikView/sorting-the-dimension-in-pivot-table/m-p/621349#M1115996 Nicole-Smith 2014-02-07T14:45:59Z Re: sorting the dimension in pivot table https://community.qlik.com/t5/QlikView/sorting-the-dimension-in-pivot-table/m-p/621350#M1115997 <HTML><HEAD></HEAD><BODY><P>Set the sort order of the Job dimension to Text A-&gt;Z on the Sort tab of the properties window.</P></BODY></HTML> Fri, 07 Feb 2014 14:46:05 GMT https://community.qlik.com/t5/QlikView/sorting-the-dimension-in-pivot-table/m-p/621350#M1115997 Gysbert_Wassenaar 2014-02-07T14:46:05Z Re: sorting the dimension in pivot table https://community.qlik.com/t5/QlikView/sorting-the-dimension-in-pivot-table/m-p/621351#M1115998 <HTML><HEAD></HEAD><BODY><P>So Job is not one of the options that is displayed within sort, so this is what I did, within sort, select any one of the dimensions, in my example above I would select Testname and add expression =job then select ascending order and text (A-Z).</P></BODY></HTML> Fri, 07 Feb 2014 14:50:01 GMT https://community.qlik.com/t5/QlikView/sorting-the-dimension-in-pivot-table/m-p/621351#M1115998 2014-02-07T14:50:01Z Re: sorting the dimension in pivot table https://community.qlik.com/t5/QlikView/sorting-the-dimension-in-pivot-table/m-p/621352#M1115999 <HTML><HEAD></HEAD><BODY><P>Thank you for response</P></BODY></HTML> Fri, 07 Feb 2014 14:50:16 GMT https://community.qlik.com/t5/QlikView/sorting-the-dimension-in-pivot-table/m-p/621352#M1115999 2014-02-07T14:50:16Z Re: sorting the dimension in pivot table https://community.qlik.com/t5/QlikView/sorting-the-dimension-in-pivot-table/m-p/621353#M1116000 <HTML><HEAD></HEAD><BODY><P>Thank you for your response</P></BODY></HTML> Fri, 07 Feb 2014 14:50:27 GMT https://community.qlik.com/t5/QlikView/sorting-the-dimension-in-pivot-table/m-p/621353#M1116000 2014-02-07T14:50:27Z